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


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to