Re: [BUGS] BUG #5711: input out of error with haversine formual

2010-10-15 Thread Dean Rasheed
On 15 October 2010 05:58, Vince vincecar...@gmail.com wrote: The following bug has been logged online: Bug reference:      5711 Logged by:          Vince Email address:      vincecar...@gmail.com PostgreSQL version: 8.4 Operating system:   Linux Description:        input out of error with

Re: [BUGS] BUG #5711: input out of error with haversine formual

2010-10-15 Thread Tom Lane
Vince vincecar...@gmail.com writes: If I break this down the following returns 1: SELECT (cos(radians(37.7438640)) * cos(radians(37.7438640)) * cos(radians(-97.4631299) - radians(-97.4631299)) + sin(radians(37.7438640)) * sin(radians(37.743864000))); No, it doesn't return 1, it returns

[BUGS] BUG #5711: input out of error with haversine formual

2010-10-14 Thread Vince
The following bug has been logged online: Bug reference: 5711 Logged by: Vince Email address: vincecar...@gmail.com PostgreSQL version: 8.4 Operating system: Linux Description:input out of error with haversine formual Details: The following will return an input out