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
sqlite-users mailing list

Reply via email to