Tom,
> There's not a whole lot of interest around here in emulating Oracle's
> proprietary CONNECT BY syntax. Some work has been done towards
> implementing the SQL99 standard's features for "recursive queries"
> (WITH et al), but it's unfinished work as of 7.4.
But we have CONNECT_BY as a function, thanks to Joe Conway.
--
Josh Berkus
Aglio Database Solutions
San Francisco