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 1hUzyQ-00086t-V0 for pgsql-docs@arkaria.postgresql.org; Sun, 26 May 2019 20:42:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hUzyP-0001ZN-7K for pgsql-docs@arkaria.postgresql.org; Sun, 26 May 2019 20:42:29 +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 1hUzyO-0001ZD-Su for pgsql-docs@lists.postgresql.org; Sun, 26 May 2019 20:42:29 +0000 Received: from mout.gmx.net ([212.227.17.22]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hUzyH-0001pK-SF for pgsql-docs@lists.postgresql.org; Sun, 26 May 2019 20:42:27 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1558903337; bh=S2beALlYF/Qpm5jAWYxXWA9uiK7HEV7o9v5c7qOn0No=; h=X-UI-Sender-Class:From:Subject:Date:In-Reply-To:Cc:To:References; b=j9T6dBejlH4ffwn5rpqEU7hxPsLIQ/2uaMG5+I8TcWQdeiIYd3NBxwxyDOVdKvayX ULotbpOpKGDoIQ87YB7M4o5pxe218LmKc9CQh7VqUYFWnuMiX/uKRfLXwnBSljSjD8 BxvL5OprgEJH+TS2ocRid/JlfXSbQ2pToUljSTqk= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from [192.168.11.4] ([51.154.165.237]) by mail.gmx.com (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MWigq-1h6fgW3X0C-00X4UB; Sun, 26 May 2019 22:42:16 +0200 From: Tobias Bussmann Message-Id: <3232E7C8-8182-403A-9BF1-06D23410BAEF@gmx.net> Content-Type: multipart/mixed; boundary="Apple-Mail=_FAE63F1A-851B-4CFA-BEE9-CBEC09371265" Mime-Version: 1.0 (Mac OS X Mail 11.5 \(3445.9.1\)) Subject: Re: Docs for Generated Columns Date: Sun, 26 May 2019 22:42:15 +0200 In-Reply-To: <9997d7e0-b0d9-1ec5-365d-153b58ad533e@joeconway.com> Cc: Joe Conway To: pgsql-docs@lists.postgresql.org References: <071F9108-0335-4309-ACD3-262AF04A1817@gmx.net> <9997d7e0-b0d9-1ec5-365d-153b58ad533e@joeconway.com> X-Mailer: Apple Mail (2.3445.9.1) X-Provags-ID: V03:K1:IoCSqAvNkmCxXBwmThsltzTHFiq/PDyS3qafGgtwlFrmlBwP0/x ONMfHYq/Sw7WyVRbgKdiGfJz4yG7CdgYP+VGxH6JJqTzrlvy4fKbIOYRuvFlPjmQsaHQ/uk 9R2Bv4BIm6mQNQB/Q85ZVJd42XEhULiXXXJMSm6SXXMPWA8tWc3N/zXrPS53f9dEALEBWNx iMBKXmXwJEsdNrbIrDIRg== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:grGGeAKHExY=:XctEtM0x3yc7Zs2JaASGB4 KN4z25Z/Q9s4e9NlVSLEDhuIhJcsRpINhPhuaiRG1u5TggEq5YZHgTaXW7jxRl6nQY1aWc9HU x7gV27xor2FzXo50sq69tO3qil1tuvwcnJqGxx9hEFx5Dxz7MtUQZaEZiBHLXwyL3+nLYr5WB HoYhnfKXvTjlSeHnzC9zmViOHq+RF2sfR88hrCjyKJkeaIBqy57Z/Zhjj2slxhwK8RldRV0gD XcEWrpMWivcAIEnO171dQMYiDsbKplJ/gvgoExR0M/1+V6WymOpa9v0A1rrF/t9qX9f8x5iyU neFLLdAua95kaTMNxZoMd6GUwiXN45NJFJrg15CSKCqCT9yJQTzAy9SusozFBMDCqMnGOsf7c pRbzsQ+M74owZeefQtVGlxm/WLFnjMjtX74p0i0Lb/L7rOxQyDZwlwrr6mL9UW0uB1bP+EySK ZMLoZ1isWlE7NKkUX4t+9E3lyvfDHiBKtdht3L2+ExO2Mb+VIQsGNJ26yTJ6O/tPjGmo0PZvk F3gfqxWuzLwkH04UmrQZMJ4LR8pJAsIVCsIYruIgfbGw4xvDN1t9MFVeb8ieABjQZ49aTC2q6 nqFmIRxOIQY06q29JYbOctxNeyFKSZ/NnJWGQJwHtkJooRPjOLQfF9MtPGOVyI7nKxfiecKEA /xp4YmEm3nCl3Eb1n7Kqorc6fbIvgrTocIZ5SgALPqI1kOKVCfmPal/DyALkiElSk67Z9oi9O rj2NmA70Zrck+aEj2E0rBb/ioHiFqOCJOgbl7Ioz0NLGe7V3BqYKJSeDAvwf3fx4kVyisi5R0 or5AGajqHpOXsYtAc+aBY0R4nW6RdBVyzsuFB2ViJxigMv1an/xUf5KrP2jPyF3+sYNuR4GIf 7kK3boRBwIO//+KyBf9LvO9PIPIGA9/cbL4rmU9M95E6CwU7TpPmCsHYnhJzDNUUJjfSVVg6O wJ2hDNfIhKWfcZIIYhKLU0M1iAGQQ4/M= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Apple-Mail=_FAE63F1A-851B-4CFA-BEE9-CBEC09371265 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii On 24.05.2019 14:21, Joe Conway wrote: >> The column cannot be written to, and when read the result of the >> specified expression will be returned. > That sounds reasonable to me. Thank you for confirmation and review. Please find attached my proposed = little doc patch for this issue. Tobias --Apple-Mail=_FAE63F1A-851B-4CFA-BEE9-CBEC09371265 Content-Disposition: attachment; filename=001-reword-gen-col-docs.patch Content-Type: application/octet-stream; x-unix-mode=0644; name="001-reword-gen-col-docs.patch" Content-Transfer-Encoding: quoted-printable diff --git a/doc/src/sgml/ref/create_foreign_table.sgml b/doc/src/sgml/ref= /create_foreign_table.sgml index 5db15eb73e..25d2f09ed2 100644 =2D-- a/doc/src/sgml/ref/create_foreign_table.sgml +++ b/doc/src/sgml/ref/create_foreign_table.sgml @@ -268,8 +268,8 @@ CHECK ( expression ) [ NO INHERIT ] This clause creates the column as a generated - column. The column cannot be written to, and when read= it - will be computed from the specified expression. + column. The column cannot be written to, and when read= the + result of the specified expression will be returned. diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_= table.sgml index 44a61ef99e..8e1bfe4d78 100644 =2D-- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -813,8 +813,8 @@ WITH ( MODULUS numeri= c_literal, REM This clause creates the column as a generated - column. The column cannot be written to, and when read= it - will be computed from the specified expression. + column. The column cannot be written to, and when read= the + result of the specified expression will be returned. --Apple-Mail=_FAE63F1A-851B-4CFA-BEE9-CBEC09371265--