On 5 Jul 2018, at 7:30am, Clemens Ladisch <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
