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