Обсуждение: Transitive Closure and CONNECT BY

Поиск
Список
Период
Сортировка

Transitive Closure and CONNECT BY

От
Robert James
Дата:
Is there a transitive closure (or equivalent) operator in Postgres (or extension)?
Anything like CONNECT BY?
Or any recommended way of querying hiearchial data?

Re: Transitive Closure and CONNECT BY

От
Thomas Kellerer
Дата:
Robert James wrote on 26.07.2009 21:35:
> Anything like CONNECT BY?
> Or any recommended way of querying hiearchial data?
>
Yes, recursive common table expression (since 8.4)

http://www.postgresql.org/docs/current/static/queries-with.html

Thomas