Quick, without trying it out, what would you expect the following statement to 
return:

select 1 where 1 - 1;

(a) one row
(b) no row
(c) syntax error

For extra entertainment, try some variations:

select 1 where 1;
select 1 where 0;
etc...

Bonus points for a rationalization of any of the behaviors you see or don’t see.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to