Re: Triggers - need help !!! - Mailing list 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