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 BerkusAglio Database SolutionsSan Francisco