Re: [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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
>

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