Eric wrote:
> How do I access hierarchical data under PostgreSQL?
> Does it have SQL command similar to Oracle's CONNECT BY?
>
In addition to all the other good suggestions, if you are using Postgres
version 7.3.x, take a look at contrib/tablefunc for a function called
connectby().
HTH,
Joe
