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
>"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
Sent from my Android device with K-9 Mail. Please excuse my brevity.
sqlite-users mailing list