Re: [COMMITTERS] pgsql: Add trigonometric functions that work in degrees.

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [COMMITTERS] pgsql: Add trigonometric functions that work in degrees.
Date: 2016-04-05 01:16:33
Message-ID: 570311F1.6020902@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers 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?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2016-04-05 01:20:37 Re: Re: [COMMITTERS] pgsql: Add trigonometric functions that work in degrees.
Previous Message David Rowley 2016-04-05 01:09:54 Re: oversight in parallel aggregate

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Paquier 2016-04-05 01:20:37 Re: Re: [COMMITTERS] pgsql: Add trigonometric functions that work in degrees.
Previous Message Michael Paquier 2016-04-05 00:18:28 Re: pgsql: Avoid archiving XLOG_RUNNING_XACTS on idle server