> I saw on the todo list that the "with recursive" option for selects > (equivalent to oracle's connect by, as far as I know) is on the todo > list for postgresql, but apparently not for the upcoming 8.3 release. the postgresql derivate enterprisedb has this feature (exactly the oracle syntax) ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq