From 436e6af2ad8d0898612156dbb12a78f8cd22e455 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Wed, 24 Sep 2008 19:51:22 +0000 Subject: [PATCH] Add documentation about when trigger values NEW/OLD return NULL. Jeff Davis --- doc/src/sgml/plpgsql.sgml | 8 +++++--- 1 file changed, 5 insertions(+), 3 deletions(-) diff --git a/doc/src/sgml/plpgsql.sgml b/doc/src/sgml/plpgsql.sgml index e47142078c..6b8c6c832c 100644 --- a/doc/src/sgml/plpgsql.sgml +++ b/doc/src/sgml/plpgsql.sgml @@ -1,4 +1,4 @@ - + <application>PL/pgSQL</application> - <acronym>SQL</acronym> Procedural Language @@ -3036,7 +3036,8 @@ RAISE unique_violation USING MESSAGE = 'Duplicate user ID: ' || user_id; Data type RECORD; variable holding the new database row for INSERT/UPDATE operations in row-level - triggers. This variable is NULL in statement-level triggers. + triggers. This variable is NULL in statement-level triggers + and for DELETE operations. @@ -3047,7 +3048,8 @@ RAISE unique_violation USING MESSAGE = 'Duplicate user ID: ' || user_id; Data type RECORD; variable holding the old database row for UPDATE/DELETE operations in row-level - triggers. This variable is NULL in statement-level triggers. + triggers. This variable is NULL in statement-level triggers + and for INSERT operations. -- 2.40.0