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 | 685d6cb8cd4c2909c94b4b7c050cd9767cda26cf (patch) | |
| tree | 3d404c43bbb7950f4dde0543c9c5e1e0b0947efd | |
| parent | baa483984fdeacd2c07a48c24a357977e048e0f8 (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.sgml | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/doc/src/sgml/trigger.sgml b/doc/src/sgml/trigger.sgml index 4d3fc8e0f89..647d96ef1d8 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</>, |