
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 


Mon, 10 Jul 2000 00:03:52 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
[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 



Mon, 10 Jul 2000 00:07:02 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
Re: [7.0.2] should this work? geo_distance() ...