Re: [SQL] Need a little help with geometric query

2011-08-25 Thread Samuel Gendler
On Thu, Aug 25, 2011 at 3:56 PM, wrote: > 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 l

[SQL] Need a little help with geometric query

2011-08-25 Thread lxnf98mm
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 ot