Re: Passing parameters to a Trigger - Mailing list pgsql-novice

From Tom Lane
Subject Re: Passing parameters to a Trigger
Date
Msg-id 22388.1043776781@sss.pgh.pa.us
Whole thread Raw
In response to Re: Passing parameters to a Trigger  (Antonio Scotti <ascotti@mbigroup.it>)
List pgsql-novice
Antonio Scotti <ascotti@mbigroup.it> writes:
>     The exact reference to what I've read is: in the .pdf file
> "programmer-7.2-A4.pdf" at the very beginning of page 240. It is the
> programmer's reference manual, the section regardings the CREATE TRIGGER
> command in the paragraph explaing the meaning of 'args'.
>     It says something about passing the current_user to a trigger but it
> is not clear to me so I'd like to have it explained.

No, what it's suggesting is passing two field names (constant strings)
to a trigger, which then uses those as the names of the fields to stick
current user and current time values into.  The trigger would have to
compute current user and current time for itself.

            regards, tom lane

pgsql-novice by date:

Previous
From: Steve_Miller@sil.org
Date:
Subject: Re: Learning Plpgsql ??
Next
From: Steve_Miller@sil.org
Date:
Subject: Re: collation