Re: Passing arguments to a function called by a trigger

From: amulsul <sul_amul(at)yahoo(dot)co(dot)in>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Passing arguments to a function called by a trigger
Date: 2013-07-29 01:22:39
Message-ID: 1375060959730-5765394.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

>Is there a corresponding OLD as well if I ever want to do a trigger on
an UPDATE?

Yes, you are correct.

ODL is variable holding the old database row for UPDATE/DELETE operations in
row-level triggers and NEW is holding the new database row.

To get to know more about trigger just follow the tutorial at
http://wiki.postgresql.org/wiki/A_Brief_Real-world_Trigger_Example

I am sure u get more idea about it.

Regards,
Amul Sul

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Passing-arguments-to-a-function-called-by-a-trigger-tp5765350p5765394.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Luca Ferrari 2013-07-29 06:38:39 Re: Using wildcard for table name ?
Previous Message Andreas Kretschmer 2013-07-27 13:05:39 Re: Passing arguments to a function called by a trigger