From: | "Vince" <vincecarney(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #5711: input out of error with haversine formual |
Date: | 2010-10-15 04:58:23 |
Message-ID: | 201010150458.o9F4wNcj092342@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5711
Logged by: Vince
Email address: vincecarney(at)gmail(dot)com
PostgreSQL version: 8.4
Operating system: Linux
Description: input out of error with haversine formual
Details:
The following will return an input out of error as the acos() function
cannot be -1 <= x <= 1.
SELECT * FROM
(SELECT *, (3959 * acos(cos(radians(37.7438640)) *
cos(radians(37.7438640)) * cos(radians(-97.4631299) -
radians(-97.4631299)) + sin(radians(37.7438640)) *
sin(radians(37.7438640))))
AS distance
FROM foo) AS distances
WHERE distance < 10
ORDER BY distance
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)));
acos(1) would give me 0.
Thoughts?
From | Date | Subject | |
---|---|---|---|
Next Message | Dean Rasheed | 2010-10-15 07:23:24 | Re: BUG #5711: input out of error with haversine formual |
Previous Message | Bruce Momjian | 2010-10-14 22:46:09 | Re: BUG #5682: Postgres Service crashes with exception 0xC0000135 |