> -----Original Message----- > From: Igor Tandetnik [mailto:[EMAIL PROTECTED] > Sent: Saturday, May 12, 2007 9:41 PM > To: SQLite > Subject: [sqlite] Re: Table with 2 primary keys... what's the problem? > > Darren Duncan <[EMAIL PROTECTED]> wrote: > > At 11:37 PM +0100 5/12/07, Paulo J. Matos wrote: > > SQLite does not have a boolean data type, though I think it really > > should; the boolean type is fundamental to the relational model of > > data. For example, what is the data type of the expression in a > > WHERE clause if not a boolean? > > It's an int, with 1 meaning true and 0 meaning false. C language managed > without boolean quite happily for some 35 years now.
A boolean type was finally added to standard C 8 years ago. (Not quite in the same way as one was added to C++ before that, unfortunately, and in C the type of x==y is still int, whereas in C++ it's bool.) -- James ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------