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
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 |