Re: Triggers - need help !!! - Mailing list pgsql-sql

From Tomasz Myrta
Subject Re: Triggers - need help !!!
Date
Msg-id 40EBA43A.4070802@klaster.net
Whole thread Raw
In response to Triggers - need help !!!  ("Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar.Pyatalo@honeywell.com>)
List pgsql-sql
On 2004-07-07 08:45, Użytkownik Pradeepkumar, Pyatalo (IE10) napisał:
> Hi,
> 
> I am writing some triggers for my project.
> I am writing a trigger on a table after delete....I want to know how u refer
> to the row that is being deleted.
> 
> For example for a trigger function after INSERT/UPDATE u refer to the row
> being inserted/updated using NEW like this....

Use OLD instead of NEW.
You can also use OLD inside UPDATE triggers - you have access to row 
before update.

Regards,
Tomasz Myrta



pgsql-sql by date:

Previous
From: "Pradeepkumar, Pyatalo (IE10)"
Date:
Subject: Triggers - need help !!!
Next
From: "Pradeepkumar, Pyatalo (IE10)"
Date:
Subject: Re: Triggers - need help !!!