Commit5292570

committed

docs: clarify that only INSERT and UPDATE triggers can mod. NEW

The point is that DELETE triggers cannot modify any values.Reported-by: Eugen KonkovDiscussion:https://postgr.es/m/919823407.20191029175436@yandex.ruBackpatch-through: 9.4

1 parent831ca95 commit5292570Copy full SHA for 5292570

File tree

-1

lines changed

-1

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -207,7 +207,7 @@`
`207`	`207`	`used to signal that the trigger performed the necessary data`
`208`	`208`	`modifications in the view. This will cause the count of the number`
`209`	`209`	`of rows affected by the command to be incremented. For`
`210`		`- <command>INSERT</> and <command>UPDATE</> operations, the trigger`
	`210`	`+ <command>INSERT</> and <command>UPDATE</> operations only, the trigger`
`211`	`211`	`may modify the <varname>NEW</> row before returning it. This will`
`212`	`212`	`change the data returned by`
`213`	`213`	`<command>INSERT RETURNING</> or <command>UPDATE RETURNING</>,`

Comments

(0)