Re: triggers and TriggerData

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