Skip site navigation (1) Skip section navigation (2)

Re: query question really cant give a summary here so read the body ;-)

From: Colin Wetherbee <cww(at)denterprises(dot)org>
To: Rhys Stewart <rhys(dot)stewart(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: query question really cant give a summary here so read the body ;-)
Date: 2008-04-25 17:07:42
Message-ID: 48120FDE.3060601@denterprises.org (view raw or flat)
Thread:
Lists: pgsql-general
Rhys Stewart wrote:
> The example I provided earlier was a very simplified model of the table 
> I'm working with after a self join. The table in question contains 
> geographic data (linestrings)

PostGIS LINESTRINGs?

 > and I have written a function to return a
> textual representation

Like ST_AsEWKT()?

 > so that  I can easily identify lines with similar
> configuration. I want to now  select  lines that are in close proximity 
> to each other and have the same configuration. So this requires a self 
> join (afaik). So, short of a function like the one that was posited 
> earlier, is there a method using just plain old sql to get the results I 
> desire?

Surely, you don't mean ST_Distance()?

What do you mean by "similar configuration"?

Colin

In response to

Responses

pgsql-general by date

Next:From: D. Dante LorensoDate: 2008-04-25 17:10:47
Subject: Sync some database tables, but not others ... WAS Re: How to modify ENUM datatypes?
Previous:From: andy petrellaDate: 2008-04-25 17:07:02
Subject: Re: Full Text Search

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group