Re: [HACKERS] Incompatible trig error handling

2015-06-12 Thread Noah Misch
On Wed, Apr 29, 2015 at 05:11:48PM -0700, Tom Lane wrote: > John Gorman 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 par

Re: [HACKERS] Incompatible trig error handling

2015-04-29 Thread Tom Lane
John Gorman 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

[HACKERS] Incompatible trig error handling

2015-04-29 Thread John Gorman
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. On Linux: SELECT asin(2); > ERROR: input is out of range > SELECT acos(2); > ERROR: input is out of range On OSX: SELECT