> > In Oracle i use the command "connect by prior" and i need to use it in > > PostgreSQL, what is the sintax? > > I was unable to find pg-hier in a quick cruise through PgFoundry. Try http://gppl.moonbone.ru/ The patch is not yet fixed to 8.2.0. 8.1.2 looks to be the latest.