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
<dan...@agelektronik.se> wrote:
That's because the expression in the WHEN clause
(new.value != old.value)
is not valid when one of them is NULL.
HTH
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
