In standard SQL, you cannot write expr1 IS expr2
(Only "expr1 IS NULL" is permitted.) You have to write: expr1 IS NOT DISTINCT FROM expr2 Are there any plans to add the second syntax to SQLite? This version also supports comparing multiple values at once, as in: (expr1, expr2) IS NOT DISTINCT FROM (expr3, expr4) Arguably, expr1 IS expr3 AND expr2 IS expr4 is much clearer, but it is not portable. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
