Josh,
Thanks man, good to know.
Sorry if the question was a bit out of place on this list
but I wanted to make sure I reached the right people.
I love what you guys are doing and made sure postgresql
was included in my book.
also, while I got your ear. I bugged Simon about this
earlier this year and was wondering if you guys are still
planning on added the window functions added to the '03 standard?
I have a ton of recipes that use them and if you guys are still
planning on implementing them, I'd like to mention that as well.
Thanks, Anthony
-----Original Message-----
From: Josh Berkus [mailto:josh@agliodbs.com]
Sent: Thursday, September 22, 2005 2:43 PM
To: Anthony Molinaro
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] 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