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

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(at)wgen(dot)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(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of Josh Berkus
> Sent: Thursday, September 22, 2005 2:02 PM
> To: pgsql-hackers(at)postgresql(dot)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/