Re: [HACKERS] CONNECT BY PRIOR

2005-11-15 Thread Hannu Krosing
On T, 2005-11-15 at 09:53 +0100, Martijn van Oosterhout wrote: > On Tue, Nov 15, 2005 at 01:38:31AM -0500, Jonah H. Harris wrote: > > Hey Simon, > > I'm doing some research into recursive query planning in terms of theory > > as-well-as actual implementation in other RDBMS. Let me get back to you

Re: [HACKERS] CONNECT BY PRIOR

2005-11-15 Thread Martijn van Oosterhout
On Tue, Nov 15, 2005 at 04:13:47PM +0200, Hannu Krosing wrote: > On T, 2005-11-15 at 09:53 +0100, Martijn van Oosterhout wrote: > > On Tue, Nov 15, 2005 at 01:38:31AM -0500, Jonah H. Harris wrote: > > > Hey Simon, > > > I'm doing some research into recursive query planning in terms of theory > > >

Re: [HACKERS] CONNECT BY PRIOR

2005-11-15 Thread Martijn van Oosterhout
On Tue, Nov 15, 2005 at 01:38:31AM -0500, Jonah H. Harris wrote: > Hey Simon, > I'm doing some research into recursive query planning in terms of theory > as-well-as actual implementation in other RDBMS. Let me get back to you when > I have some more definitive info. My first reaction would be to

Re: [HACKERS] CONNECT BY PRIOR

2005-11-14 Thread Jonah H. Harris
Hey Simon,   I'm doing some research into recursive query planning in terms of theory as-well-as actual implementation in other RDBMS.  Let me get back to you when I have some more definitive info.     On 11/14/05, Simon Riggs <[EMAIL PROTECTED]> wrote: On Sat, 2005-11-12 at 15:27 -0500, Jonah H. H

Re: [HACKERS] CONNECT BY PRIOR

2005-11-14 Thread Simon Riggs
On Sat, 2005-11-12 at 15:27 -0500, Jonah H. Harris wrote: > I am working on the standard WITH syntax for recursive query support > and hope to get it into 8.2. Sounds interesting. What approach are you taking to the plan shape? The current approach would be to have additional plan nodes for each

Re: [HACKERS] CONNECT BY PRIOR

2005-11-12 Thread Samer Abukhait
That's GREAT news, hope you can make it to 8.2 .. it will be really a good hit On 11/13/05, Yann Michel <[EMAIL PROTECTED]> wrote: > Hi, > > On Sat, Nov 12, 2005 at 03:27:32PM -0500, Jonah H. Harris wrote: > > Yann, > > > > I am working on the standard WITH syntax for recursive query support and >

Re: [HACKERS] CONNECT BY PRIOR

2005-11-12 Thread Yann Michel
Hi, On Sat, Nov 12, 2005 at 03:27:32PM -0500, Jonah H. Harris wrote: > Yann, > > I am working on the standard WITH syntax for recursive query support and > hope to get it into 8.2. Fine! Looking forward to that! Cheers, Yann ---(end of broadcast)

Re: [HACKERS] CONNECT BY PRIOR

2005-11-12 Thread Jonah H. Harris
Yann, I am working on the standard WITH syntax for recursive query support and hope to get it into 8.2. On 11/12/05, Yann Michel <[EMAIL PROTECTED]> wrote: Hi,I'm just a little bit confused because I expected postgresql to be ablet "connect by prior" but as I have seen it is not. :-(Are there

Re: [HACKERS] CONNECT BY PRIOR

2005-11-12 Thread Tom Lane
Yann Michel <[EMAIL PROTECTED]> writes: > I'm just a little bit confused because I expected postgresql to be able > t "connect by prior" but as I have seen it is not. :-( > Are there any plans to support this in the main distribution? There's some work being done to implement the SQL-standard recu

[HACKERS] CONNECT BY PRIOR

2005-11-12 Thread Yann Michel
Hi, I'm just a little bit confused because I expected postgresql to be able t "connect by prior" but as I have seen it is not. :-( Are there any plans to support this in the main distribution? If have found a patch to porstgres but I don't want to apply any patches but only use the "vanilla" postg