Postgres Pro
Downloads
Home   >   mailing lists

Re: Passing arguments to a function called by a trigger - Mailing list pgsql-novice

From amulsul
Subject Re: Passing arguments to a function called by a trigger
Date
Msg-id 1375060959730-5765394.post@n5.nabble.com
Whole thread Raw
In response to Re: Passing arguments to a function called by a trigger  (Some Developer <someukdeveloper@gmail.com>)
List pgsql-novice
Tree view 
>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.

pgsql-novice by date:

Previous
From: Some Developer
Date:
Subject: Re: Passing arguments to a function called by a trigger
Next
From: Luca Ferrari
Date:
Subject: Re: Using wildcard for table name ?