On Wed, 1 Dec 2004, D. Richard Hipp wrote:
I have lately noticed a need for an "IS" operator in SQLite. IS would work just like "=" for most things. The difference is that "IS" would compares NULLs as equals. There would, of course, need to be a corresponding "IS NOT" operator.
You can already us the IS operator with a right-hand side of NULL. For example: "x IS NULL" or "x IS NOT NULL". What I am proposing is to expand IS so that the right-hand side can be an arbitrary expression. Like this: "x IS 5" or "x IS NOT y".
The motivation for this change is so that one can compile statements that use "?" as the right-hand side of IS and then insert NULL or a value as appropriate.
Thoughts?
sounds great. i'm fond of '==' or '===' though - but perhaps this is reserved or too confusing.
-a -- =============================================================================== | EMAIL :: Ara [dot] T [dot] Howard [at] noaa [dot] gov | PHONE :: 303.497.6469 | When you do something, you should burn yourself completely, like a good | bonfire, leaving no trace of yourself. --Shunryu Suzuki ===============================================================================
