Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kyHnQ-00070x-Hq for pgsql-docs@arkaria.postgresql.org; Sat, 09 Jan 2021 17:13:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kyHnM-0000gc-NO for pgsql-docs@arkaria.postgresql.org; Sat, 09 Jan 2021 17:12:56 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kyHm7-0006bs-UQ for pgsql-docs@lists.postgresql.org; Sat, 09 Jan 2021 17:11:39 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kyHm5-0004aG-FE for pgsql-docs@lists.postgresql.org; Sat, 09 Jan 2021 17:11:39 +0000 Received: from bruce by momjian.us with local (Exim 4.92) (envelope-from ) id 1kyHm3-0007Ku-JP; Sat, 09 Jan 2021 12:11:35 -0500 Date: Sat, 9 Jan 2021 12:11:35 -0500 From: Bruce Momjian To: fotis.koutoupas@gmail.com, pgsql-docs@lists.postgresql.org Subject: Re: Potential typo in abbreviated insertion query Message-ID: <20210109171135.GA19555@momjian.us> References: <160912275508.676.17469511338925622905@wrigleys.postgresql.org> <20201231184456.GG22199@momjian.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20201231184456.GG22199@momjian.us> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Thu, Dec 31, 2020 at 01:44:56PM -0500, Bruce Momjian wrote: > On Mon, Dec 28, 2020 at 02:32:35AM +0000, PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > > > Page: https://www.postgresql.org/docs/13/executor.html > > Description: > > > > It's located within the parentheses of the last paragraph. > > > > >(A simple INSERT ... VALUES command creates a trivial plan tree consisting > > of a single Result node, which computes just one result row, and ModifyTable > > above it to perform the insertion. But INSERT ... SELECT can demand the full > > power of the executor mechanism.) > > > > I'm under the impression that the second inline code block refers to `INSERT > > ... VALUES`. > > I think the text is correct, but I also think it is trying to do too > much in one paragraph. Here is a doc patch to improve this. Patch applied to all supported branches. -- Bruce Momjian https://momjian.us EnterpriseDB https://enterprisedb.com The usefulness of a cup is in its emptiness, Bruce Lee