Dun, Oracles "CONNECT BY" and SQL99 recursive queries are two quite different beasts. I am not sure which one you expect will be included into PG
This quite recent thread discusses the matter
http://archives.postgresql.org/pgsql-hackers/2004-06/msg00969.php
and seems to indicate that
- "CONNECT BY", or at least the currently existing implementation, will not be included any time soon.
- SQL99 recursion had not been implemented then.
/Nis
BTW: How come most mail archives suck so greatly for viewing articles by thread (ie the way you want to do it 99% of the time).
