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

From Michael Paquier
Subject Re: Re: [COMMITTERS] pgsql: Add trigonometric functions that work in degrees.
Date
Msg-id CAB7nPqT5bpu+BHubrqCjDW4_N1Nu3S832Kz-A7P1W9KGgsTuSw@mail.gmail.com
Whole thread Raw
In response to Re: [COMMITTERS] pgsql: Add trigonometric functions that work in degrees.  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Re: [COMMITTERS] pgsql: Add trigonometric functions that work in degrees.  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Re: [COMMITTERS] pgsql: Add trigonometric functions that work in degrees.  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
On Tue, Apr 5, 2016 at 10:16 AM, Peter Eisentraut <peter_e@gmx.net> wrote:
> 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?

Likely an oversight not tracked by the buildfarm. What are you using here?
-- 
Michael



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [COMMITTERS] pgsql: Add trigonometric functions that work in degrees.
Next
From: Peter Eisentraut
Date:
Subject: Re: Correction for replication slot creation error message in 9.6