Thanks a lot for ur help.
In the trigger, I am checking if a field is updated or not. The syntax I
use is
IF UPDATE(CreateTime) THEN
....
....
END IF;
Is this syntax correct.
-----Original Message-----
From: Tomasz Myrta [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 07, 2004 12:50 PM
To: Pradeepkumar, Pyatalo (IE10)
Cc: [EMAIL PROTECTED]
Subject: Re: [SQL] Triggers - need help !!!
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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
