On 10/6/17, J. King <jk...@jkingweb.ca> wrote: > Are there any other > reasons I might perhaps want to use = rather than IS that I'm not aware > of?
"NULL IS NULL" is true, but "NULL = NULL" is not true (it is null). Other than that, the IS operator and the = operator are the same. "IS" in SQLite is the same as "IS NOT DISTINCT FROM" in PostgreSQL and "IS NOT" in SQLite is the ame as "IS DISTINCT FROM" in PostgreSQL. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users