Re: [COMMITTERS] pgsql: Add trigonometric functions that work in degrees. - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [COMMITTERS] pgsql: Add trigonometric functions that work in degrees.
Date
Msg-id 570311F1.6020902@gmx.net
Whole thread Raw
Responses Re: Re: [COMMITTERS] pgsql: Add trigonometric functions that work in degrees.  (Michael Paquier <michael.paquier@gmail.com>)
Re: Re: [COMMITTERS] pgsql: Add trigonometric functions that work in degrees.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 01/22/2016 03:46 PM, Tom Lane wrote:
> Add trigonometric functions that work in degrees.
>
> The implementations go to some lengths to deliver exact results for values
> where an exact result can be expected, such as sind(30) = 0.5 exactly.

I have a host here that is having regression test failures from this commit:

--- src/test/regress/expected/float8.out
+++ src/test/regress/results/float8.out
@@ -490,9 +490,9 @@   x   | asind | acosd | atand ------+-------+-------+-------    -1 |   -90 |   180 |   -45
- -0.5 |   -30 |   120 |
+ -0.5 |       |   120 |     0 |     0 |    90 |     0
-  0.5 |    30 |    60 |
+  0.5 |       |    60 |     1 |    90 |     0 |    45 (5 rows)

Any ideas?




pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: oversight in parallel aggregate
Next
From: Michael Paquier
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Add trigonometric functions that work in degrees.