From 0729271adf9145900f59ec7a2053695bd551f4b1 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Wed, 15 Aug 2012 20:29:58 -0400 Subject: [PATCH] Properly document that NEW is unassigned in plpgsql for DELETE (not NULL), and OLD is unassigned for INSERT, and NEW/OLD are unassigned (not NULL) for statement-level triggers. Per report from Pavel Stehule --- doc/src/sgml/plpgsql.sgml | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/doc/src/sgml/plpgsql.sgml b/doc/src/sgml/plpgsql.sgml index ab40845650..07fba57c0e 100644 --- a/doc/src/sgml/plpgsql.sgml +++ b/doc/src/sgml/plpgsql.sgml @@ -3403,7 +3403,7 @@ 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 unassigned in statement-level triggers and for DELETE operations. @@ -3415,7 +3415,7 @@ 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 unassigned in statement-level triggers and for INSERT operations. -- 2.40.0