Re: triggers and TriggerData - Mailing list pgsql-general

From Alan Hodgson
Subject Re: triggers and TriggerData
Date
Msg-id 200701220824.59664@hal.medialogik.com
Whole thread Raw
In response to Re: triggers and TriggerData  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
On Monday 22 January 2007 07:04, Michael Fuhr <mike@fuhr.org> wrote:
> You can pass literal string arguments to a trigger function.  See
> the CREATE TRIGGER documentation and, for PL/pgSQL, TG_ARGV and
> TG_NARGS.  For C see "Writing Trigger Functions in C"; search for
> tgnargs and tgargs.
>
> http://www.postgresql.org/docs/8.2/interactive/sql-createtrigger.html
> http://www.postgresql.org/docs/8.2/interactive/plpgsql-trigger.html
> http://www.postgresql.org/docs/8.2/interactive/trigger-interface.html
>
> (These links are to the 8.2 documentation but earlier versions also
> support arguments to trigger functions.)

I stand corrected.  And I can imagine some uses for passing string constants
to triggers, but nothing related to what the OP was looking for ...

--
99 percent of lawyers give the rest a bad name


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Enable/Disable Triggers
Next
From: Bruno Wolff III
Date:
Subject: Re: Password encryption method