summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2019-11-07 15:49:59 -0500
committerBruce Momjian <bruce@momjian.us>2019-11-07 15:49:59 -0500
commitb7ee1d345b68b0cecfc3c2f2e2f99ab2c4371964 (patch)
treee1d6ad21bcb0672fc3effe12fe6ef33695a2ecd1
parentb705d639146ce994a52a65db0c4e263aab312bde (diff)
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.sgml2
1 files changed, 1 insertions, 1 deletions
diff --git a/doc/src/sgml/trigger.sgml b/doc/src/sgml/trigger.sgml
index 3cf48c87ad3..6cdb603a5d0 100644
--- a/doc/src/sgml/trigger.sgml
+++ b/doc/src/sgml/trigger.sgml
@@ -204,7 +204,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</> and <command>UPDATE</> operations, the trigger
+ <command>INSERT</> and <command>UPDATE</> operations only, the trigger
may modify the <varname>NEW</> row before returning it. This will
change the data returned by
<command>INSERT RETURNING</> or <command>UPDATE RETURNING</>,