On Oct 27, 2009, at 12:15 PM, Tom Sillence wrote: > 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 >
See the second bullet on http://www.sqlite.org/releaselog/3_6_19.html This feature of the IS operator was added in version 3.6.19. I suspect you are running an older version. D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users