pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
"5.3. Identity Columns" Incorrect Usage of "VALUE" in Documentation
2+ messages / 2 participants
[nested] [flat]

* "5.3. Identity Columns" Incorrect Usage of "VALUE" in Documentation
@ 2024-10-22 08:12 PG Doc comments form <noreply@postgresql.org>
  2024-10-23 12:21 ` Re: "5.3. Identity Columns" Incorrect Usage of "VALUE" in Documentation Daniel Gustafsson <daniel@yesql.se>
  0 siblings, 1 reply; 2+ messages in thread

From: PG Doc comments form @ 2024-10-22 08:12 UTC (permalink / raw)
  To: pgsql-docs@lists.postgresql.org; +Cc: shixiong327926@gmail.com

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/17/ddl-identity-columns.html
Description:

In the PostgreSQL documentation regarding identity columns, the SQL syntax
examples incorrectly use the keyword "VALUE" instead of "VALUES". This error
could lead to confusion for users attempting to insert data into tables with
identity columns. The correct syntax for inserting data should read:

INSERT INTO people (name, address) VALUES ('A', 'foo');
INSERT INTO people (name, address) VALUES ('B', 'bar');

I recommend updating the documentation to correct this inconsistency for
clarity.


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: "5.3. Identity Columns" Incorrect Usage of "VALUE" in Documentation
  2024-10-22 08:12 "5.3. Identity Columns" Incorrect Usage of "VALUE" in Documentation PG Doc comments form <noreply@postgresql.org>
@ 2024-10-23 12:21 ` Daniel Gustafsson <daniel@yesql.se>
  0 siblings, 0 replies; 2+ messages in thread

From: Daniel Gustafsson @ 2024-10-23 12:21 UTC (permalink / raw)
  To: shixiong327926@gmail.com, pgsql-docs <pgsql-docs@lists.postgresql.org>

> On 22 Oct 2024, at 10:12, PG Doc comments form <noreply@postgresql.org> wrote:

> The correct syntax for inserting data should read:
> 
> INSERT INTO people (name, address) VALUES ('A', 'foo');
> INSERT INTO people (name, address) VALUES ('B', 'bar');

Nice catch, will fix.

--
Daniel Gustafsson






^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2024-10-23 12:21 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-10-22 08:12 "5.3. Identity Columns" Incorrect Usage of "VALUE" in Documentation PG Doc comments form <noreply@postgresql.org>
2024-10-23 12:21 ` Daniel Gustafsson <daniel@yesql.se>

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