From: Tobias Bussmann <t.bussmann@gmx.net>
To: pgsql-docs@lists.postgresql.org
Subject: Docs for Generated Columns
Date: Thu, 23 May 2019 23:50:12 +0200
Message-ID: <071F9108-0335-4309-ACD3-262AF04A1817@gmx.net> (raw)
Hi,
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. 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.
Best regards
Tobias Bussmann
[1]: https://www.postgresql.org/docs/devel/sql-createtable.html
[2]: https://www.postgresql.org/docs/devel/sql-createforeigntable.html
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: t.bussmann@gmx.net, pgsql-docs@lists.postgresql.org
Subject: Re: Docs for Generated Columns
In-Reply-To: <071F9108-0335-4309-ACD3-262AF04A1817@gmx.net>
* 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