Need a little help with geometric query - Mailing list pgsql-sql

From lxnf98mm@comcast.net
Subject Need a little help with geometric query
Date
Msg-id alpine.LRH.2.00.1108251749470.17085@rray.drdc.mstc.ms.gov
Whole thread Raw
Responses Re: Need a little help with geometric query  (Samuel Gendler <sgendler@ideasculptor.com>)
List pgsql-sql
This is my first shot at using postgresql's geometric functions
I have a passel of lines defined by x1 y1 x2 y2
I created a table with type lseg and loaded it
I start by finding the line that has an end closest to 0,0
Now I want to find the next line that has an end closest to the first line's other end and so on
I want to find the shortest path
I see there are a lot of geometric operators but I am a bit baffled
Can someone offer suggestions or reading references

Thanks
Richard


pgsql-sql by date:

Previous
From: ppdcc@sapo.pt
Date:
Subject: st_offsetcurve
Next
From: Brent Dombrowski
Date:
Subject: Re: st_offsetcurve