Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Steve_MillerDate: 2003-01-28 18:03:19
Subject: Re: collation
Previous:From: Art ForeDate: 2003-01-28 17:54:22
Subject: Re: postgresql with SuSE 8.0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group