On Thu, Sep 22, 2005 at 05:37:51PM -0400, Jonah H. Harris wrote:
> 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
> hi
ostgresql.org; Jonah H. HarrisSubject: 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
D]
Sent: Thursday, September 22, 2005 3:05 PM
To: pgsql-hackers@postgresql.org
Cc: Anthony Molinaro
Subject: Re: [HACKERS] Hierarchical Queries--Stalled No Longer...
Anthony,
> also, while I got your ear. I bugged Simon about this
> earlier this year and was wondering if you guys are s
Anthony,
> 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
From: Josh Berkus [mailto:[EMAIL PROTECTED]
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)?
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 synta
--
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 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 y
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
TOAS
"Jonah H. Harris" <[EMAIL PROTECTED]> writes:
> Evgen Potemkin has granted me a BSD license on the patch for hierarchical
> queries (WITH and CONNECT BY) and I'd like to get it on track for PostgreSQ=
> L
> 8.2. Tom, Bruce, Simon, Alvaro, Josh, et al., have you guys used the patch?
If this is the
Alvaro,
I agree, there are some things that need to be done before calling it a
done-deal including some planning, commenting, optimizer stuff,
etc. Also, for PostgreSQL reasons, I agree that supporting
ANSI/ISO WITH is the best option; I'm willing to take on implementation
for both if you guys w
On Thu, Sep 22, 2005 at 11:19:13AM -0400, Jonah H. Harris wrote:
Hi,
> Evgen Potemkin has granted me a BSD license on the patch for hierarchical
> queries (WITH and CONNECT BY) and I'd like to get it on track for PostgreSQL
> 8.2. Tom, Bruce, Simon, Alvaro, Josh, et al., have you guys used the pa
11 matches
Mail list logo