On May 5, 2014, at 9:15 PM, RSmith <rsm...@rsweb.co.za> wrote: > Je suis desole mon ami…
Moi aussi :P I have no quarrel with you, good Sir Knight, but I must cross this bridge: select 1 where 1 is 1; select 1 where 1 is not 1; select 1 where 1 is ( 1 = 1 ); select 1 in ( null ); — oh… select 1 in ( not null ); — really? Anyway… if, as Stephan Beal mentioned earlier on, one looks at SQLite’s SQL parser as some sort of glorified calculator, then, yes, it all makes perfect sense in some kind of wonderful way... :) http://www.sqlite.org/src/finfo?name=src/parse.y http://www.sqlite.org/src/artifact/22d6a074e5f5a7258947a1dc55a9bf946b765dd0 N.B. One more, just for fun: sqlite> select 1 in ( null is null ); > 1 sqlite> select 1 in ( null is not null ); > 0 m'kay... _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
