Thank you, I see.
Any suggestion how to get the trigger to fire if (and only if) the
values are different, including if one of the "sides" of old/new are null?
Den 2016-10-13 kl. 11:56, skrev Kees Nuyt:
On Thu, 13 Oct 2016 11:45:14 +0200, Daniel Polski
That's because the expression in the WHEN clause
(new.value != old.value)
is not valid when one of them is NULL.
sqlite-users mailing list