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

Reply via email to