[postgis-users] Solar azimuth calculator

[Bruce Rindahl]

As an added bonus putting it in the wiki makes bug fixes easier.

The line:

 - extract( timezone from now())/3600;

should read:

 - extract( timezone from obs_time)/3600;

;)

On Sun, Apr 18, 2021, 9:03 AM Bruce Rindahl <bruce.rindahl at gmail.com> wrote:

> 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.
> 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.
> I think a better idea is to add it to the users wiki
> https://trac.osgeo.org/postgis/wiki/UsersWikiMain and promote that.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20210418/307c2996/attachment.html>