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

Reply via email to