SQLite Forum

operators IS TRUE and IS FALSE missing from diagrams and table plus possible evaluation errors
Login
I appreciate seeing a good start on getting these wrinkles ironed out. (And seeing it sans extra diddling or other distraction is a bonus!)

What do you think of:<code>
  sqlite> select 'zip' is false;
  1
  sqlite> select false is 'zip';
  0
</code>, making it appear FALSE with "IS" is only commutative for numbers?