Dear,

3.23.0 (pending) cites:

>       • Recognize TRUE and FALSE as constants. (For compatibility, if there 
> are columns named "true" or "false", then the identifiers refer to the 
> columns rather than Boolean constants.)
>       • Support operators IS TRUE, IS FALSE, IS NOT TRUE, and IS NOT FALSE.

What values will be considered FALSE, and hence will TRUE be NOT FALSE or 
equality to some other specific value?
Will insert into T values(FALSE) actually store integer 0 no matter column 
affinity or will it follow affinity?

I guess there is a page of documentation being drafted to answer these, but 
attempting to find it using the search button on www.sqlite.org/draft, the 
request https://www.sqlite.org/draft/search?s=d&q=TRUE returns an "App 
Application Error" page.

Thanks,
-- 
Best Regards, Meilleures salutations, Met vriendelijke groeten,
Olivier Mascia


_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to