Horton

Thread

Commits

  1. doc: Fix INSERT statement syntax for identity columns

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

    The Post Office <noreply@postgresql.org> — 2024-10-22T08:12:01Z

    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.

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

    Daniel Gustafsson <daniel@yesql.se> — 2024-10-23T12:21:53Z

    > 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