Commitc10fae2

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 parentc8cb98e commitc10fae2Copy full SHA for c10fae2

File tree

-1

lines changed

-1

lines changed

Lines changed: 1 addition & 1 deletion

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

Comments

(0)