Chris, Robert > As a side note, I thought Joe Conway also had an implementation of > this...
Yes, we already have a connect_by function, and have had since 7.3. Look in /contrib/tablefuc. I think that's as far as we want to go implementing Oracle's syntax, though *external* patches are of course good for GBorg. If we're to implement recursive queries, we should implement the SQL99 standard. -- -Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html