On Sep 20, 2011, at 5:58, Thomas Kellerer <spam_eater(at)gmx(dot)net> 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 recursive keyword after the "with" if any of the following CTEs are recursive.
WITH RECURSIVE
normal1 AS ()
,recursine1 AS ()
,normal2 AS ()
,recursine2 AS ()
SELECT ...
David J.