New answers tagged datatypes
2
Change the if condition to:
if (new.col1 != old.col1) or ( new.col1 is not null and old.col1 is null )
That should solve your problem. The original code didn't work correctly as you can't test for equality with a NULL value - you have to use IS NULL or IS NOT NULL.
Top 50 recent answers are included
