Is there a boolean literal in SQLite?
From my question on StackOverflow (CC BY-SA 3.0):
I know about the
boolean
column type, but is there aboolean
literal in SQLite? In other languages, this might betrue
orfalse
. Obviously, I can use `` and1
, but I tend to avoid so-called “magic numbers” where possible.From this list, it seems like it might exist in other SQL implementations, but not SQLite. (I’m using SQLite 3.6.10, for what it’s worth.)