Re: BUG #2037: user function call unexpected "input out of range"

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: BUG #2037: user function call unexpected "input out of range"
Дата
Msg-id 20051112202300.GA11657@wolff.to
обсуждение исходный текст
Ответ на BUG #2037: user function call unexpected "input out of range"  ("Tom" <lackey@ltu.edu>)
Список pgsql-bugs
Дерево обсуждения 
On Fri, Nov 11, 2005 at 21:26:47 +0000,
  Tom <lackey@ltu.edu> wrote:
>
>         --Calculate distance
>         select     acos
>             (
>                 sin($1*pi()/180)*sin($3*pi()/180)
>                 +
>                 cos($1*pi()/180)*cos($3*pi()/180)
> *cos(($2-$4)*pi()/180)
>             )*60*1.1515*180/pi();

In addition to the other comments, you don't want to calculate distance this
way. It isn't very accurate when $2 and $4 are nearly equal which is the
normal case.
Do a search for haversine.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: tomas@tuxteam.de (Tomas Zerolo)
Дата:
Сообщение: Re: BUG #2037: user function call unexpected "input out of range"
Следующее
От: "Qingqing Zhou"
Дата:
Сообщение: Re: storage sync failed on magnetic disk: Permission denied