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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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



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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group