* Eric <someone(at)somewhere(dot)com> [03.03.2003 17:10]:
> Hi,
>
> How do I access hierarchical data under PostgreSQL?
> Does it have SQL command similar to Oracle's CONNECT BY?
>
> Any help is appreciated
I've have the same problem recently.
I've combined nested sets with adjacency list model, perfect solution, IMHO.
Read more about nested sets here:
http://www.brasileiro.net:8080/postgres/cookbook/view-recipes.adp?section_id=310&format=long
--
Victor Yegorov