Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iWi8q-0007Nh-Bw for pgsql-docs@arkaria.postgresql.org; Mon, 18 Nov 2019 14:36:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iWi8o-00061X-41 for pgsql-docs@arkaria.postgresql.org; Mon, 18 Nov 2019 14:36:34 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iWi8n-00061Q-SY for pgsql-docs@lists.postgresql.org; Mon, 18 Nov 2019 14:36:33 +0000 Received: from mail.i-mark.de ([188.138.104.222]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iWi8h-00081R-7x for pgsql-docs@lists.postgresql.org; Mon, 18 Nov 2019 14:36:33 +0000 Received: from [192.168.178.20] (unknown [185.38.49.17]) by mail.i-mark.de (Postfix) with ESMTPSA id CEDC01583B4D for ; Mon, 18 Nov 2019 15:36:21 +0100 (CET) Authentication-Results: loft7616.startdedicated.de; spf=pass (sender IP is 185.38.49.17) smtp.mailfrom=andreas@a-kretschmer.de smtp.helo=[192.168.178.20] Received-SPF: pass (loft7616.startdedicated.de: connection is authenticated) To: pgsql-docs@lists.postgresql.org From: Andreas Kretschmer Subject: documentation for WITH RECURSIVE Message-ID: Date: Mon, 18 Nov 2019 15:36:24 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.9.0 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi, 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. Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company. www.2ndQuadrant.com