Postgres Pro
Downloads
Home   >   mailing lists

Re: Is "WITH RECURSIVE" limited to the first position of CTEs by design? - Mailing list pgsql-general

From David G. Johnston
Subject Re: Is "WITH RECURSIVE" limited to the first position of CTEs by design?
Date
Msg-id CAKFQuwZfQyMFThrAg5r4=D2373GaQ-iZChXCOW6dKGrxjBGzvw@mail.gmail.com
Whole thread Raw
In response to Is "WITH RECURSIVE" limited to the first position of CTEs by design?  (Kirk Wolak <wolakk@gmail.com>)
Responses Re: Is "WITH RECURSIVE" limited to the first position of CTEs by design?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
On Mon, Nov 13, 2023 at 9:17 AM Kirk Wolak <wolakk@gmail.com> wrote:
These are the most trivial examples.  The second one results in a syntax error.  Which implies that:
1) There can only be one recursive CTE at the same level?
2) It must be the FIRST CTE?

There is only one WITH keyword as well, that doesn't change the fact there can be multiple attached queries to it.

The documentation explains clearly the implications on adding the keyword RECURSIVE after the keyword WITH.

https://www.postgresql.org/docs/current/sql-select.html#SQL-WITH

David J.

pgsql-general by date:

Previous
From: Shaik Mohammad Mujeeb
Date:
Subject: Re: Issue in compiling postgres on latest macOS 14.1.1
Next
From: Adrian Klaver
Date:
Subject: Re: Unique Primary Key Linked to Multiple Accounts