diff options
| author | Bruce Momjian <bruce@momjian.us> | 2008-09-24 19:51:22 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2008-09-24 19:51:22 +0000 |
| commit | 436e6af2ad8d0898612156dbb12a78f8cd22e455 (patch) | |
| tree | b8026ab8edce99e6caeb9eeb1960e4a942f30fb5 | |
| parent | fb4bb8b9c5715b0b7da042153af879a740182c14 (diff) | |
| download | postgresql-436e6af2ad8d0898612156dbb12a78f8cd22e455.tar.gz postgresql-436e6af2ad8d0898612156dbb12a78f8cd22e455.zip | |
Add documentation about when trigger values NEW/OLD return NULL.
Jeff Davis
| -rw-r--r-- | doc/src/sgml/plpgsql.sgml | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/doc/src/sgml/plpgsql.sgml b/doc/src/sgml/plpgsql.sgml index e47142078c0..6b8c6c832c1 100644 --- a/doc/src/sgml/plpgsql.sgml +++ b/doc/src/sgml/plpgsql.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/plpgsql.sgml,v 1.133 2008/07/18 03:32:51 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/plpgsql.sgml,v 1.134 2008/09/24 19:51:22 momjian Exp $ --> <chapter id="plpgsql"> <title><application>PL/pgSQL</application> - <acronym>SQL</acronym> Procedural Language</title> @@ -3036,7 +3036,8 @@ RAISE unique_violation USING MESSAGE = 'Duplicate user ID: ' || user_id; <para> Data type <type>RECORD</type>; variable holding the new database row for <command>INSERT</>/<command>UPDATE</> operations in row-level - triggers. This variable is <symbol>NULL</symbol> in statement-level triggers. + triggers. This variable is <symbol>NULL</symbol> in statement-level triggers + and for <command>DELETE</command> operations. </para> </listitem> </varlistentry> @@ -3047,7 +3048,8 @@ RAISE unique_violation USING MESSAGE = 'Duplicate user ID: ' || user_id; <para> Data type <type>RECORD</type>; variable holding the old database row for <command>UPDATE</>/<command>DELETE</> operations in row-level - triggers. This variable is <symbol>NULL</symbol> in statement-level triggers. + triggers. This variable is <symbol>NULL</symbol> in statement-level triggers + and for <command>INSERT</command> operations. </para> </listitem> </varlistentry> |