| From: | Tomasz Myrta <jasiek(at)klaster(dot)net> |
|---|---|
| To: | "Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar(dot)Pyatalo(at)honeywell(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Triggers - need help !!! |
| Date: | 2004-07-07 07:20:26 |
| Message-ID: | 40EBA43A.4070802@klaster.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pradeepkumar, Pyatalo (IE10) | 2004-07-07 08:48:42 | Re: Triggers - need help !!! |
| Previous Message | Pradeepkumar, Pyatalo (IE10) | 2004-07-07 06:45:29 | Triggers - need help !!! |