BUG #5711: input out of error with haversine formual
От | Vince |
---|---|
Тема | BUG #5711: input out of error with haversine formual |
Дата | |
Msg-id | 201010150458.o9F4wNcj092342@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #5711: input out of error with haversine formual
Re: BUG #5711: input out of error with haversine formual |
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 5711 Logged by: Vince Email address: vincecarney@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 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?
В списке pgsql-bugs по дате отправления: