On Mon, May 5, 2014 at 7:31 PM, Petite Abeille <petite.abei...@gmail.com>wrote:
> On May 5, 2014, at 7:15 PM, Stephan Beal <sgb...@googlemail.com> wrote: > > Why expect an error? It's abstractly the same as saying WHERE 'a' = 'b’, > > I mean ‘where 1’, or ‘where ‘1 - 1’, or ‘where null’, or ‘where 0 / 0’, or > any of this nonsense. There is nothing to compare. It’s nonsensical. > Oh, but there is: 1-1 is an expression, the result of which is integer 0 (as opposed to string '0'), which, in all programming environments except, IIRC, Xenix, is boolean false. In fact, the sqlite shell makes a handy ad hoc calculator for exactly that purpose: sqlite> select 1-1; 0 sqlite> select typeof(1-1); integer -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do." -- Bigby Wolf _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users