Received-SPF: pass (loft7616.startdedicated.de: connection is authenticated)
Subject: Re: documentation for WITH RECURSIVE
To: pgsql-docs@lists.postgresql.org
References: <ca53c6ce-a0c6-b14a-a8e3-162f0b2cc119@a-kretschmer.de>
 <20712.1574098328@sss.pgh.pa.us>
 <94685a79-0b75-34ad-16bb-e1f23eb28c24@a-kretschmer.de>
From: Andreas Kretschmer <andreas@a-kretschmer.de>
Message-ID: <ec7286da-5698-40a3-b8f4-e8e90b035cd2@a-kretschmer.de>
Date: Tue, 19 Nov 2019 13:29:39 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101
 Thunderbird/60.9.0
MIME-Version: 1.0
In-Reply-To: <94685a79-0b75-34ad-16bb-e1f23eb28c24@a-kretschmer.de>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Language: en-US
Precedence: bulk


Am 18.11.19 um 20:12 schrieb Andreas Kretschmer:
>
>
> 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?
>>
>

Hi Tom,

it would be good if we can also add this to chapter 7.8, wouldn't it?


Regards, Andreas

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