The documentation, http://sqlite.org/lang_expr.html suggests that "is" behaves like "=" except that "null is null" returns true. However in practice the sqlite sql parser won't accept the word "is" followed by anything other than "null" (oh and I suppose "not" as in "is not").
sqlite> select 1 is 2; SQL error: near "2": syntax error sqlite> select 1 is null; 0 It seems to me the documentation is wrong here. That said I'd much rather the behaviour of sqlite changed to match the docs rather than vice-versa because I really want to write neat queries like: select col1 is col2 from table Cheers Tom Sillence _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
