On Wed, Oct 26, 2005 at 07:00:06PM -0600, Michael Fuhr wrote: > You *can* pass arguments to trigger functions but it's done a little > differently than with non-trigger functions. The function must be > defined to take no arguments; it reads the arguments from a context > structure instead of in the normal way. PL/pgSQL trigger functions, > for example, read their arguments from the TG_ARGV array. > > http://www.postgresql.org/docs/8.0/interactive/plpgsql-trigger.html > http://www.postgresql.org/docs/8.0/interactive/trigger-interface.html Also http://www.postgresql.org/docs/8.0/interactive/sql-createtrigger.html where the documentation says CREATE TRIGGER name { BEFORE | AFTER } { event [ OR ... ] } ON table [ FOR [ EACH ] { ROW | STATEMENT } ] EXECUTE PROCEDURE funcname ( arguments ) ... arguments An optional comma-separated list of arguments to be provided to the function when the trigger is executed. The arguments are literal string constants. Simple names and numeric constants may be written here, too, but they will all be converted to strings. Please check the description of the implementation language of the trigger function about how the trigger arguments are accessible within the function; it may be different from normal function arguments. -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
