From: Joe Conway <mail@joeconway.com>
To: Tobias Bussmann <t.bussmann@gmx.net>
To: pgsql-docs@lists.postgresql.org
Subject: Re: Docs for Generated Columns
Date: Fri, 24 May 2019 08:21:57 -0400
Message-ID: <9997d7e0-b0d9-1ec5-365d-153b58ad533e@joeconway.com> (raw)
In-Reply-To: <071F9108-0335-4309-ACD3-262AF04A1817@gmx.net>
References: <071F9108-0335-4309-ACD3-262AF04A1817@gmx.net>
On 5/23/19 5:50 PM, Tobias Bussmann wrote:
> while reading though the docs of the upcoming pg12 features, I
> stumbled upon some wording regarding generated columns: both in
> create_table.sgml [1] and create_foreign_table.sgml [2] the paragraph
> for the GENERATED ALWAYS AS clause is introduced with
>> 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.
> To me this sounds confusing, if not wrong. Till v8 of the patch were
> STORED and VIRTUAL generated columns were described afterwards this
> was less obvious but now with only STORED it sounds like a reference
> to the VIRTUAL variant.
No doubt this is flat out wrong.
> Not being I native english speaker I'm restrained to send a patch but
> may I suggest the following for discussion:
> The column cannot be written to, and when read the result of the
> specified expression will be returned.
That sounds reasonable to me.
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development
Attachments:
signature.asc (application/pgp-signature, 832B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: mail@joeconway.com, t.bussmann@gmx.net, pgsql-docs@lists.postgresql.org
Subject: Re: Docs for Generated Columns
In-Reply-To: <9997d7e0-b0d9-1ec5-365d-153b58ad533e@joeconway.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox