Postgres Pro
Downloads
Home   >   mailing lists

Thread: Transitive Closure and CONNECT BY

Transitive Closure and CONNECT BY

From
Robert James
Date:
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

From
Thomas Kellerer
Date:
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