Re: Triggers - need help !!!

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar(dot)Pyatalo(at)honeywell(dot)com>
Cc: Tomasz Myrta <jasiek(at)klaster(dot)net>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Triggers - need help !!!
Date: 2004-07-07 11:03:45
Message-ID: 40EBD891.3050205@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Pradeepkumar, Pyatalo (IE10) wrote:
> 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.

No, and I don't recall seeing anything like it in the manuals.

IF OLD.CreateTime <> NEW.CreateTime THEN
...

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mischa Sandberg 2004-07-07 12:43:43 Re: Triggers - need help !!!
Previous Message Pradeepkumar, Pyatalo (IE10) 2004-07-07 08:48:42 Re: Triggers - need help !!!