Re: documentation for WITH RECURSIVE

Am 18.11.19 um 18:32 schrieb Tom Lane:
> Andreas Kretschmer <andreas(at)a-kretschmer(dot)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