[SQL] Hierarchical Queries

[clemens schmuck]

hi there,
in the database i'm currently trying to implement i make heavy use of self 
joins and therefore i do often need to make hierarchical queries. oracle 
offers the connect by clause to do this. how can i do this with, postgresql?

clemens