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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
