Re: [SQL] Combining several CTEs with a recursive CTE

2011-09-20 Thread Thomas Kellerer
David Johnston, 20.09.2011 16:15: I'm just wondering if this is intended behavioury, simply not (yet) implemented or even invalid according to the standard? I didn't find any reference that it's not allowed in the manual. Regards Thomas Try sticking the recursive keyword after the "with" if a

Re: [SQL] Combining several CTEs with a recursive CTE

2011-09-20 Thread David Johnston
On Sep 20, 2011, at 5:58, Thomas Kellerer wrote: > > I'm just wondering if this is intended behavioury, simply not (yet) > implemented or even invalid according to the standard? I didn't find any > reference that it's not allowed in the manual. > > Regards > Thomas > > Try sticking the rec