Whoops, sorry, you are perfectly correct. I've been caught out like this before, the online docs tantalising me with features that aren't in my version of sqlite. I suppose I must restrict myself to the locally-installed docs for my version.
Cheers, Tom Sillence 2009/10/27 D. Richard Hipp <d...@hwaci.com> > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
