diff options
| author | Bruce Momjian <bruce@momjian.us> | 2019-11-07 15:49:59 -0500 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2019-11-07 15:49:59 -0500 |
| commit | 353647fd93c0ce871e6da3cc785220fcac17985e (patch) | |
| tree | 17fd772cc925f5e1e36ec1379e633e2efbd60bc9 | |
| parent | 89f56fc223f94c0e0c0347aa9fc18d1a247bc316 (diff) | |
| download | postgresql-353647fd93c0ce871e6da3cc785220fcac17985e.tar.gz postgresql-353647fd93c0ce871e6da3cc785220fcac17985e.zip | |
docs: clarify that only INSERT and UPDATE triggers can mod. NEW
The point is that DELETE triggers cannot modify any values.
Reported-by: Eugen Konkov
Discussion: https://postgr.es/m/919823407.20191029175436@yandex.ru
Backpatch-through: 9.4
| -rw-r--r-- | doc/src/sgml/trigger.sgml | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/doc/src/sgml/trigger.sgml b/doc/src/sgml/trigger.sgml index be9c2284481..f372f0ab8e9 100644 --- a/doc/src/sgml/trigger.sgml +++ b/doc/src/sgml/trigger.sgml @@ -230,7 +230,7 @@ used to signal that the trigger performed the necessary data modifications in the view. This will cause the count of the number of rows affected by the command to be incremented. For - <command>INSERT</command> and <command>UPDATE</command> operations, the trigger + <command>INSERT</command> and <command>UPDATE</command> operations only, the trigger may modify the <varname>NEW</varname> row before returning it. This will change the data returned by <command>INSERT RETURNING</command> or <command>UPDATE RETURNING</command>, |