Re: [GENERAL] Update Triggers & NULLs

2001-05-02 Thread Doug McNaught
"Gregory Wood" <[EMAIL PROTECTED]> writes: > I have a plpgsql update trigger on one of my tables. The intention of the > trigger is to check to see if a particular field is updated, and if so > INSERT a record into another table. The IF statement looks something like > this: > > IF new.MyField <

[GENERAL] Update Triggers & NULLs

2001-05-02 Thread Gregory Wood
I have a plpgsql update trigger on one of my tables. The intention of the trigger is to check to see if a particular field is updated, and if so INSERT a record into another table. The IF statement looks something like this: IF new.MyField <> old.MyField THEN This works great when MyField has an