Klaas Van B. wrote: > Since 3.23 the words FALSE and TRUE should be added to SQLite Query Language: > SQLite Keywords.
But FALSE and TRUE are not keywords. <http://www.sqlite.org/lang_keywords.html> says that | keywords ... may not be used as the names of tables, indices, columns, | ... or any other named object. While <http://www.sqlite.org/lang_expr.html#booleanexpr> says that | SQLite recognizes the *identifiers* "TRUE" and "FALSE" as boolean | literals, if and only if those identifiers are not already used for | some other meaning. If there already exists columns or tables or other | objects named TRUE or FALSE, then for the sake of backwards | compatibility, the TRUE and FALSE identifiers refer to those other | objects, not to the boolean values. In other words, TRUE and FALSE behave like predefined global variables. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users