Anthony,
> So is postgresql going into the direction of WITH or CONNECT BY (or
> both)?
PostgreSQL would do ONLY "with". We're not interested in
Oracle-proprietary syntax.
That being said, there is a CONNECT_BY() function in /contrib/tablefunc.
But this would never be part of the core syntax.
> I am authoring O'Reilly's "SQL Cookbook" and I'd like to mention it in
> the
> Hierarchical chapter to give the pg readers a heads up.
Keen. Please feel free to ask questions so that the PG section can be as
accurate as possible. #postgresql on irc.freenode.net is quite active,
and you can get any number of Postgres - SQL questions answered there.
--Josh
--
__Aglio Database Solutions_______________
Josh Berkus Consultant
josh@agliodbs.com www.agliodbs.com
Ph: 415-752-2500 Fax: 415-752-2387
2166 Hayes Suite 200 San Francisco, CA