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

Поиск
Список
Период
Сортировка
От Colin Wetherbee
Тема Re: query question really cant give a summary here so read the body ;-)
Дата
Msg-id 48120FDE.3060601@denterprises.org
обсуждение исходный текст
Ответ на Re: query question really cant give a summary here so read the body ;-)  ("Rhys Stewart" <rhys.stewart@gmail.com>)
Ответы Re: query question really cant give a summary here so read the body ;-)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: "andy petrella"
Дата:
Сообщение: Re: Full Text Search
Следующее
От: "D. Dante Lorenso"
Дата:
Сообщение: Sync some database tables, but not others ... WAS Re: How to modify ENUM datatypes?