<html><head></head><body style="zoom: 0%;"><div dir="auto">The reason is that I need special permission to use this at my company since it is not part of the standard package. Technically there is no issue. <br><br></div>
<div dir="auto"><!-- tmjah_g_1299s -->Get <!-- tmjah_g_1299e --><a href="http://www.bluemail.me/r?b=16696"><!-- tmjah_g_1299s -->BlueMail for Android<!-- tmjah_g_1299e --></a><!-- tmjah_g_1299s --> <!-- tmjah_g_1299e --></div>
<div class="gmail_quote" >On Apr 18, 2021, at 10:27 AM, Bruce Rindahl <<a href="mailto:bruce.rindahl@gmail.com" target="_blank">bruce.rindahl@gmail.com</a>> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div dir="auto">
<div>
As an added bonus putting it in the wiki makes bug fixes easier.
</div>
<div dir="auto">
<br>
</div>
<div dir="auto">
The line:
</div>
<div dir="auto">
<pre style="white-space:pre-wrap"> - extract( timezone from now())/3600;</pre>
</div>
<div dir="auto">
should read:
</div>
<div dir="auto">
<pre style="white-space:pre-wrap"> - extract( timezone from obs_time)/3600;</pre>
</div>
<div dir="auto">
;)
</div>
<div dir="auto">
<br>
<div class="gmail_quote" dir="auto">
<div dir="ltr" class="gmail_attr">
On Sun, Apr 18, 2021, 9:03 AM Bruce Rindahl <
<a href="mailto:bruce.rindahl@gmail.com">bruce.rindahl@gmail.com</a>> wrote:
<br>
</div>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="auto">
<div class="gmail_quote" dir="auto">
<div dir="ltr" class="gmail_attr">
Why do you need it as a native function? Even if it was it wouldn't be available until PG 15/Postgis 3.3 at the earliest and then you would force everyone to upgrade. I think this function would work on PG 8.
</div>
<div dir="ltr" class="gmail_attr">
Remember PG SQL is Turing complete. This means anything you want to do can be done in pure SQL. The only benefit of a native function is speed/memory.
</div>
<div dir="ltr" class="gmail_attr">
I think a better idea is to add it to the users wiki
<a href="https://trac.osgeo.org/postgis/wiki/UsersWikiMain" target="_blank" rel="noreferrer">https://trac.osgeo.org/postgis/wiki/UsersWikiMain</a> and promote that.
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
<pre class="blue"> <hr><br>postgis-users mailing list<br>postgis-users@lists.osgeo.org<br><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br></pre></blockquote></div></body></html>