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

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