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


sqlite-users mailing list

Reply via email to