Re: "5.3. Identity Columns" Incorrect Usage of "VALUE" in Documentation

[Daniel Gustafsson]

> On 22 Oct 2024, at 10:12, PG Doc comments form  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

"5.3. Identity Columns" Incorrect Usage of "VALUE" in Documentation

[PG Doc comments form]

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.