Re: documentation for WITH RECURSIVE

Am 18.11.19 um 18:32 schrieb Tom Lane:
> Andreas Kretschmer <andreas@a-kretschmer.de> writes:
>> One of our customers had problems with the syntax of WITH RECURSIVE. He
>> suggested that the documentation should be improved, maybe with this
>> sentence:
>> "If any of the CTEs is recursive, the recursive keywork must be present
>> after with", so to make sure that it does not refer to just one of the
>> named subqueries.
> Hm, was this intended for the SELECT man page (presumably in the
> "WITH Clause" section), or for section 7.8?
>
> In the SELECT page, I'd be inclined to put it after the para about
> "queries need not be ordered" and phrase it more like
>
>    If there are multiple queries in the WITH clause, RECURSIVE can
>    be written only once, immediately after WITH.  It applies to all
>    queries in the WITH clause (but has no effect on queries that do
>    not use either of these features).
>
>             regards, tom lane

yeah, sounds good to me, thx Tom.

Regards, Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com