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