pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feeddoc correction
2+ messages / 2 participants
[nested] [flat]
* doc correction
@ 2019-10-28 22:41 PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2019-10-28 22:41 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: jasonwang.public@gmail.com
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/ddl-generated-columns.html
Description:
https://www.postgresql.org/docs/12/ddl-generated-columns.html
In the below
"Consider the differences between a column with a default and a generated
column. The column default is evaluated once when the row is first inserted
if no other value was provided; a generated column is updated whenever the
row changes and cannot be overridden. A column default may not refer to
other columns of the table; a generation expression would normally do so. A
column default can use volatile functions, for example random() or functions
referring to the current time; this is not allowed for generated columns."
"a generation expression would normally do so" should be changed to "a
generated column" for easier reading
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: doc correction
@ 2019-10-29 09:17 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
parent: PG Doc comments form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: Peter Eisentraut @ 2019-10-29 09:17 UTC (permalink / raw)
To: jasonwang.public@gmail.com; pgsql-docs@lists.postgresql.org
On 2019-10-28 23:41, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/12/ddl-generated-columns.html
> Description:
>
> https://www.postgresql.org/docs/12/ddl-generated-columns.html
>
> In the below
> "Consider the differences between a column with a default and a generated
> column. The column default is evaluated once when the row is first inserted
> if no other value was provided; a generated column is updated whenever the
> row changes and cannot be overridden. A column default may not refer to
> other columns of the table; a generation expression would normally do so. A
> column default can use volatile functions, for example random() or functions
> referring to the current time; this is not allowed for generated columns."
>
> "a generation expression would normally do so" should be changed to "a
> generated column" for easier reading
The current wording seems more precise. It's the expression that does
the referencing, not the column itself. There could be other things
attached to a column to could reference other things or not.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2019-10-29 09:17 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-10-28 22:41 doc correction PG Doc comments form <noreply@postgresql.org>
2019-10-29 09:17 ` Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
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