Missing keywords

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Missing keywords

KlaasV
Since 3.23 the words FALSE and TRUE should be added to SQLite Query Language: SQLite Keywords. Perhaps more?


|
|
|  |
SQLite Query Language: SQLite Keywords


 |

 |

 |




Kind regards | Vriendelijke groeten | Cordiali saluti,
Klaas `Z4us` van B. V, EFIG

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Klaas "Z4us" V, MetaDBA at InnocentIsArt.EU
Reply | Threaded
Open this post in threaded view
|

Re: Missing keywords

Clemens Ladisch
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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users