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 any of the
following CTEs are recursive.
WITH RECURSIVE normal 1 AS () ,recursine1 AS () ,normal2 AS ()
,recursine2 AS () SELECT ...
David J.
Ah! That does the trick.
Thanks
Thomas
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
