Anthony,
I'm reviewing your book :). One of the reasons that I want to add this support is because, in your recipies, it's obvious that PostgreSQL is lacking in this area... likewise, we've had several EDB requests for hierarchical queries (ala Oracle-style)... For the PostgreSQL community, I'll work on adding the ANSI/ISO WITH standard syntax just as SQL Server/DB2 have.
-Jonah
On 9/22/05, Anthony Molinaro <amolinaro@wgen.net> wrote: So is postgresql going into the direction of WITH or CONNECT BY (or
both)?
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.
Thanks and regards,
Anthony Molinaro
-----Original Message-----
From: pgsql-hackers-owner@postgresql.org
[mailto: pgsql-hackers-owner@postgresql.org] On Behalf Of Josh Berkus
Sent: Thursday, September 22, 2005 2:02 PM
To: pgsql-hackers@postgresql.org; Jonah H. Harris
Subject: Re: [HACKERS] Hierarchical Queries--Stalled No Longer...
Jonah,
> Tom, Bruce, Simon, Alvaro, Josh, et al., have you guys used the patch?
> If so, what comments do you have as to what you'd like to see.
Unfortunately, yes I have. I had to help several users who got burned by
it: the patch was buggy as all-get out. For example, it wouldn't access
TOAST tables, so any TEXT fields larger than 500chars got cut off; and
wouldn't support user-added data types or domains. (This was a year
ago,
so maybe Evgen fixed these things)
So it's really nice of Evgen to re-license, but the license was *not*
the
primary thing blocking acceptance of the patch.
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
--
Respectfully,
Jonah H. Harris, Database Internals Architect
EnterpriseDB Corporation
http://www.enterprisedb.com/