[7.0.2] should this work? geo_distance() ...

Поиск
Список
Период
Сортировка
От The Hermit Hacker
Тема [7.0.2] should this work? geo_distance() ...
Дата
Msg-id Pine.BSF.4.21.0007100000060.3314-100000@thelab.hub.org
обсуждение исходный текст
Ответы Re: [7.0.2] should this work? geo_distance() ...  (The Hermit Hacker <scrappy@hub.org>)
Список pgsql-hackers
SELECT geo_distance(location::point,'(-79.412636,43.720768)'::point) FROM location_table;

where location is defined as point already?

I'm getting:

pqReadData() -- backend closed the channel unexpectedly.       This probably means the backend terminated abnormally
  before or while processing the request.
 
The connection to the server was lost. Attempting reset: Failed.

each time ... its producing a core that I've yet to analyze,as I have to
compile a new debugging server to do so.  figured I'd check first that
what I'm trying to do is possible, before I try and 'bark up the wrong
tree' ...

thanks ...

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Re: [GENERAL] PostgreSQL vs. MySQL
Следующее
От: The Hermit Hacker
Дата:
Сообщение: Re: [7.0.2] should this work? geo_distance() ...