Re: [sqlite] The IS operator

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 wrote: >On 10/6/17, J. King wrote: >> Are t

Re: [sqlite] The IS operator

On 10/6/17, J. King 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

[sqlite] The IS operator

I've been using the IS operator to the exclusion of = in my application's queries so that I'm not surprised by some input being null and giving unexpected results. My rationale is that if I'm consistent, my software will be as well (all else being equal, anyway...). The IS operator is commonly