From: | Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> |
---|---|
To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Proposal: Trigonometric functions in degrees |
Date: | 2015-10-24 09:24:14 |
Message-ID: | CAEZATCXxdzxb2Mvi0-Xvp43tfvw-bUi703HdAJuLUd7dt5-ZgQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Currently PostgreSQL only has trigonometric functions that work in
radians. I think it would be quite useful to have an equivalent set of
functions that worked in degrees. In other environments these are
commonly spelled sind(), cosd(), etc.
Partly, this would be a matter of convenience. It's quite common to
have a problem domain where angles are specified in degrees, and it's
somewhat cumbersome having to type things like sin(radians(x)) and
degrees(asin(x)).
Additionally, functions that worked natively in degrees would be able
to return exact answers in special cases like cosd(90) = 0, whereas
cos(radians(90)) is not exactly 0 because pi/2 cannot be represented
exactly as a floating point number.
Possibly the earthdistance module would benefit from these functions too.
Thoughts?
Regards,
Dean
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2015-10-24 11:15:36 | Re: [HACKERS] JDBC driver debug out? |
Previous Message | Masahiko Sawada | 2015-10-24 08:54:16 | Re: Freeze avoidance of very large table. |