Re: Incompatible trig error handling - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Incompatible trig error handling
Date
Msg-id 35777.1430352708@sss.pgh.pa.us
Whole thread Raw
In response to Incompatible trig error handling  (John Gorman <johngorman2@gmail.com>)
Responses Re: Incompatible trig error handling
List pgsql-hackers
John Gorman <johngorman2@gmail.com> writes:
> Two of the trigonometry functions have differing error condition behavior
> between Linux and OSX. The Linux behavior follows the standard set by the
> other trig functions.

We have never considered it part of Postgres' charter to try to hide
platform-specific variations in floating-point behavior.  If we did,
we'd spend all our time doing that rather than more productive stuff.

In particular, it appears to me that both of these behaviors are allowed
per the POSIX standard, which makes it very questionable why we should
insist that one is correct and the other is not.

In addition, the proposed patch turns *all* cases that return NaN into
errors, which is wrong at least for the case where the input is NaN.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Final Patch for GROUPING SETS
Next
From: Alvaro Herrera
Date:
Subject: Re: Additional role attributes && superuser review