On 2016/10/13 1:09 PM, Hick Gunter wrote:
(new.value != old.value) or (new.value IS NULL) or (old.value IS NULL)
This will test true for a condition where new.value and old.value are both NULL (so technically not different), which may or may not be what the OP wanted.
_______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
