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

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.

> 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