On 5 Jul 2018, at 7:30am, Clemens Ladisch <clem...@ladisch.de> wrote:
> The expression "x = x" will fail for NULL, but succeed for everything > else. So you can use that to implement a "not-NULL ELSE" Wow. That has to be the most counter-intuitive feature of SQLite. I understand why it works, but I still don't like it. Thanks for posting it. Hmm. Yes, "x != x" works too. I forgot to check "x IS NOT x". Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
