[7.0.2] should this work? geo_distance() ... - Mailing list pgsql-hackers

From The Hermit Hacker
Subject [7.0.2] should this work? geo_distance() ...
Date
Msg-id Pine.BSF.4.21.0007100000060.3314-100000@thelab.hub.org
Whole thread Raw
Responses Re: [7.0.2] should this work? geo_distance() ...
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: [GENERAL] PostgreSQL vs. MySQL
Next
From: The Hermit Hacker
Date:
Subject: Re: [7.0.2] should this work? geo_distance() ...