Postgres Pro
Downloads
Home   >   mailing lists

Re: Combining several CTEs with a recursive CTE - Mailing list pgsql-sql

From David Johnston
Subject Re: Combining several CTEs with a recursive CTE
Date
Msg-id 1E5EC0E1-13DB-4346-B8EE-212F4DC4CCEA@yahoo.com
Whole thread Raw
In response to Combining several CTEs with a recursive CTE  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: Combining several CTEs with a recursive CTE
List pgsql-sql
Tree view
On Sep 20, 2011, at 5:58, Thomas Kellerer <spam_eater@gmx.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.

pgsql-sql by date:

Previous
From: Thomas Kellerer
Date:
Subject: Combining several CTEs with a recursive CTE
Next
From: Thomas Kellerer
Date:
Subject: Re: Combining several CTEs with a recursive CTE