Thank you, Richard. After some digging I see, too, that MySQL uses <=> for that same functionality, Microsoft has a toggle for =, and Oracle nothing. I had clearly been mistaken about IS's portability.
On October 6, 2017 7:53:27 PM EDT, Richard Hipp <d...@sqlite.org> wrote: >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 -- Sent from my Android device with K-9 Mail. Please excuse my brevity. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users