Totally agree. And this is exactly why my natural first reaction was to
expect a syntax error, because in my mind you can't compare a non-boolean
expr to a boolean expr.
I need to start C-ing everything differently. Not easy... :)
Thank you (and I didn't imply there was malice, ... just a pointless check)
-----Original Message-----
From: RSmith
Sent: Tuesday, October 07, 2014 2:33 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Is there equivalent to MySQL IF() function?
a Boolean value is dichotomous and has no other possible state than the
base 2 states - so evaluating it and comparing it to an integer supporting
2^64 states or
indeed any other type of multi-value field is not useful
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users