BUG #5711: input out of error with haversine formual

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?

Responses

Browse pgsql-bugs by date

  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