Re: [HACKERS] Hierarchical Queries--Stalled No Longer...

2005-09-22 Thread Alvaro Herrera
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

Re: [HACKERS] Hierarchical Queries--Stalled No Longer...

2005-09-22 Thread Jonah H. Harris
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

Re: [HACKERS] Hierarchical Queries--Stalled No Longer...

2005-09-22 Thread Anthony Molinaro
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

Re: [HACKERS] Hierarchical Queries--Stalled No Longer...

2005-09-22 Thread Josh Berkus
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

Re: [HACKERS] Hierarchical Queries--Stalled No Longer...

2005-09-22 Thread Anthony Molinaro
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)?

Re: [HACKERS] Hierarchical Queries--Stalled No Longer...

2005-09-22 Thread Josh Berkus
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

Re: [HACKERS] Hierarchical Queries--Stalled No Longer...

2005-09-22 Thread Anthony Molinaro
-- 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

Re: [HACKERS] Hierarchical Queries--Stalled No Longer...

2005-09-22 Thread Josh Berkus
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

Re: [HACKERS] Hierarchical Queries--Stalled No Longer...

2005-09-22 Thread Tom Lane
"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

Re: [HACKERS] Hierarchical Queries--Stalled No Longer...

2005-09-22 Thread Jonah H. Harris
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

Re: [HACKERS] Hierarchical Queries--Stalled No Longer...

2005-09-22 Thread Alvaro Herrera
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

[HACKERS] Hierarchical Queries--Stalled No Longer...

2005-09-22 Thread Jonah H. Harris
Hey everyone, 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 patch?  If so, what comments do you have as to what you'd like