Hello! On Monday 01 March 2010 14:48:46 Dan Kennedy wrote: > > 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.
Oh, yes. But the 0 as result of 1='1' is incompatible. See: template1=# select 1='1'; ?column? ---------- t (1 запись) template1=# select version(); version ---------------------------------------------------------------------------------------------------------------- PostgreSQL 8.1.15 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.1.2 20061115 (prerelease) (Debian 4.1.1-21) (1 запись) And template1=# select 1='1'; ?column? ---------- t (1 запись) template1=# select version(); version ---------------------------------------------------------------------------------------------- PostgreSQL 8.3.9 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real (Debian 4.3.2-1.1) 4.3.2 And template1=# select 1='1'; ?column? ---------- t (1 row) template1=# select version(); version ---------------------------------------------------------------------------------------------------- PostgreSQL 8.4.2 on i486-pc-linux-gnu, compiled by GCC gcc-4.4.real (Debian 4.4.3-2) 4.4.3, 32-bit (1 row) Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users