On Tue, Oct 7, 2014 at 1:13 PM, Tony Papadimitriou <to...@acm.org> wrote:
> As you can see, the second select gives unexpected output, and according > to the syntax diagram it's not supposed to be a valid variation of the CASE > statement. Is that normal? http://www.sqlite.org/sessions/lang_expr.html Looks perfectly valid. "expr" can be any expression, including logical ones such as "a < 10". Logical expressions in SQLite are just like any other expressions and evaluate to 0 or 1. For example, it is perfectly legal to SELECT a.a < 10 FROM a _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users