Re: Passing parameters to a Trigger

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Antonio Scotti <ascotti(at)mbigroup(dot)it>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Passing parameters to a Trigger
Date: 2003-01-28 17:59:41
Message-ID: 22388.1043776781@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Antonio Scotti <ascotti(at)mbigroup(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Steve_Miller 2003-01-28 18:03:19 Re: collation
Previous Message Art Fore 2003-01-28 17:54:22 Re: postgresql with SuSE 8.0