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

Started by PG Bug reporting formover 1 year ago2 messagesdocs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

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.

#2Daniel Gustafsson
daniel@yesql.se
In reply to: PG Bug reporting form (#1)
Re: "5.3. Identity Columns" Incorrect Usage of "VALUE" in Documentation

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