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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
