On Mar 1, 2010, at 6:08 PM, Alexey Pechnikov wrote: >> It would seem to me that asking [1='1'] *should* return false >> because the >> numeric and character string value domains are logically disjoint, >> so no value >> from one could ever equal a value from another, and so SQLite's >> answer is correct. > > See http://sqlite.org/datatypes.html: > "If both inputs look like well-formed numbers, then they are > converted into floating point values using atof() and compared > numerically."
That document is for version 2. Version 2 and version 3 handle this kind of thing differently. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
