Postgres Pro
Downloads
Home   >   mailing lists

Re: Transitive Closure and CONNECT BY - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Transitive Closure and CONNECT BY
Date
Msg-id h4ic81$tjo$1@ger.gmane.org
Whole thread Raw
In response to Transitive Closure and CONNECT BY  (Robert James <srobertjames@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Robert James
Date:
Subject: Relational Algebra and Aggregate Functions
Next
From: Nick Boutelier
Date:
Subject: Re: Is there a RECORD[] type in plpgsql?