Commit17b4aa7

committed

doc: Fix INSERT statement syntax for identity columns

The INSERT statements in the examples were erroneously usingVALUE instead of VALUES. Backpatch to v17 where the exampleswere added througha37bb7c.Reported-by: shixiong327926@gmail.comDiscussion:https://postgr.es/m/172958472112.696.6075270400394560263@wrigleys.postgresql.orgBackpatch-through: 17

1 parent55e6d71 commit17b4aa7Copy full SHA for 17b4aa7

File tree

-3

lines changed

-3

lines changed

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -271,8 +271,8 @@ CREATE TABLE people (`
`271`	`271`	`example, with the above definitions and assuming additional appropriate`
`272`	`272`	`columns, writing`
`273`	`273`	`<programlisting>`
`274`		`-INSERT INTO people (name, address)VALUE ('A', 'foo');`
`275`		`-INSERT INTO people (name, address)VALUE ('B', 'bar');`
	`274`	`+INSERT INTO people (name, address)VALUES ('A', 'foo');`
	`275`	`+INSERT INTO people (name, address)VALUES ('B', 'bar');`
`276`	`276`	`</programlisting>`
`277`	`277`	`would generate values for the <literal>id</literal> column starting at 1`
`278`	`278`	`and result in the following table data:`
`@@ -285,7 +285,7 @@ INSERT INTO people (name, address) VALUE ('B', 'bar');`
`285`	`285`	`Alternatively, the keyword <literal>DEFAULT</literal> can be specified in`
`286`	`286`	`place of a value to explicitly request the sequence-generated value, like`
`287`	`287`	`<programlisting>`
`288`		`-INSERT INTO people (id, name, address)VALUE (<emphasis>DEFAULT</emphasis>, 'C', 'baz');`
	`288`	`+INSERT INTO people (id, name, address)VALUES (<emphasis>DEFAULT</emphasis>, 'C', 'baz');`
`289`	`289`	`</programlisting>`
`290`	`290`	`Similarly, the keyword <literal>DEFAULT</literal> can be used in`
`291`	`291`	`<command>UPDATE</command> commands.`

Comments

(0)