> -----Original Message-----
> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
> Behalf Of R Smith
> Sent: donderdag 13 oktober 2016 17:37
> To: sqlite-users@mailinglists.sqlite.org
> Subject: Re: [sqlite] Trigger WHEN condition, comparing with null
>
>
>
> On 2016/10/13 1:09 PM, Hick Gunter wrote:
> > (new.value != old.value) or (new.value IS NULL) or (old.value IS NULL)
I'm guessing
(new.value IS NOT old.value)
is the check the OP wants.
(This was already noted in another mail... but it may not be obvious that you
can just perform the comparison this way instead of only checking for NULL/NOT
NULL)
Bert
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
