From 769159fd393f006f29879a71a5f2b3049251b4d9 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Fri, 8 Jul 2016 13:23:09 -0400 Subject: [PATCH] Docs: minor improvements for documentation about plpgsql triggers. Fabien Coelho, some further wordsmithing by me --- doc/src/sgml/plpgsql.sgml | 32 +++++++++++++++++++++----------- 1 file changed, 21 insertions(+), 11 deletions(-) diff --git a/doc/src/sgml/plpgsql.sgml b/doc/src/sgml/plpgsql.sgml index 7f23c2f9bc..e9cce82408 100644 --- a/doc/src/sgml/plpgsql.sgml +++ b/doc/src/sgml/plpgsql.sgml @@ -3660,18 +3660,27 @@ ASSERT condition , in PL/pgSQL + + PL/pgSQL can be used to define trigger + procedures on data changes or database events. + A trigger procedure is created with the CREATE FUNCTION + command, declaring it as a function with no arguments and a return type of + trigger (for data change triggers) or + event_trigger (for database event triggers). + Special local variables named PG_something are + automatically defined to describe the condition that triggered the call. + + Triggers on Data Changes - - PL/pgSQL can be used to define trigger - procedures. A trigger procedure is created with the - CREATE FUNCTION command, declaring it as a function with - no arguments and a return type of trigger. Note that - the function must be declared with no arguments even if it expects - to receive arguments specified in CREATE TRIGGER — - trigger arguments are passed via TG_ARGV, as described - below. + + A data change trigger is declared as a + function with no arguments and a return type of trigger. + Note that the function must be declared with no arguments even if it + expects to receive some arguments specified in CREATE TRIGGER + — such arguments are passed via TG_ARGV, as described + below. @@ -4218,8 +4227,9 @@ SELECT * FROM sales_summary_bytime; Triggers on Events - PL/pgSQL can be used to define event - triggers. PostgreSQL requires that a procedure that + PL/pgSQL can be used to define + event triggers. + PostgreSQL requires that a procedure that is to be called as an event trigger must be declared as a function with no arguments and a return type of event_trigger. -- 2.40.0