From: lxnf98mm@comcast.net
To: pgsql-sql@postgresql.org
Subject: Need a little help with geometric query
Date: Thu, 25 Aug 2011 17:56:24 -0500 (CDT)
Message-ID: <alpine.LRH.2.00.1108251749470.17085@rray.drdc.mstc.ms.gov> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: lxnf98mm@comcast.net
Subject: Re: Need a little help with geometric query
In-Reply-To: <alpine.LRH.2.00.1108251749470.17085@rray.drdc.mstc.ms.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox