Re: Hierarchical Queries--Stalled No Longer...

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