On Mon, Nov 13, 2023 at 9:17 AM Kirk Wolak <wolakk(at)gmail(dot)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.