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?
-- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
