From: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-docs(at)lists(dot)postgresql(dot)org |
Subject: | Re: documentation for WITH RECURSIVE |
Date: | 2019-11-18 19:12:09 |
Message-ID: | 94685a79-0b75-34ad-16bb-e1f23eb28c24@a-kretschmer.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Liudmila Mantrova | 2019-11-18 20:35:13 | Re: GSoD - a patch for Getting Started tutorial |
Previous Message | Tom Lane | 2019-11-18 17:32:08 | Re: documentation for WITH RECURSIVE |