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

appendum:

If I add a WHERE to it, it works fine ... its only when I try to do
*everyone* that it screws up:

SELECT geo_distance(location::point,'(-79.412636,43.720768)'::point)
FROM personal_data
WHERE gid = 14215;

geo_distance
------------------
337.832062731434
(1 row)

On Mon, 10 Jul 2000, The Hermit Hacker wrote:

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

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