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
<> wrote:

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

Reply via email to