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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general