Re: Is "WITH RECURSIVE" limited to the first position of CTEs by design?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Is "WITH RECURSIVE" limited to the first position of CTEs by design?
Дата
Msg-id CAKFQuwZfQyMFThrAg5r4=D2373GaQ-iZChXCOW6dKGrxjBGzvw@mail.gmail.com
обсуждение исходный текст
Ответ на Is "WITH RECURSIVE" limited to the first position of CTEs by design?  (Kirk Wolak <wolakk@gmail.com>)
Ответы Re: Is "WITH RECURSIVE" limited to the first position of CTEs by design?
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Shaik Mohammad Mujeeb
Дата:
Сообщение: Re: Issue in compiling postgres on latest macOS 14.1.1
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Unique Primary Key Linked to Multiple Accounts