Re: Proposal: Trigonometric functions in degrees
От | Simon Riggs |
---|---|
Тема | Re: Proposal: Trigonometric functions in degrees |
Дата | |
Msg-id | CANP8+jJuH1ARt4pz5eRc9r9sQeYrL0Kqd8=ho7H9re+n0gg8Lg@mail.gmail.com обсуждение исходный текст |
Ответ на | Proposal: Trigonometric functions in degrees (Dean Rasheed <dean.a.rasheed@gmail.com>) |
Список | pgsql-hackers |
On 24 October 2015 at 05:24, Dean Rasheed <dean.a.rasheed@gmail.com> wrote:
--
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.
That is important.
Possibly the earthdistance module would benefit from these functions too.
Thoughts?
+1, yes, please.
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
В списке pgsql-hackers по дате отправления: