On 12/9/2010 4:56 PM, Igor Tandetnik wrote: > On 12/9/2010 6:42 PM, Ryan Johnson wrote: >> create table a(x,y INTEGER); > This creates a table with column x having no affinity, and column y > having integer affinity. Is this what you meant? Doh! That explains why I couldn't repro with only a single column...
Just for clarification, though, how do comparisons work when there is no affinity? I thought it did a string compare, but that should have worked in the above case... In general, is "1"=1 ever true? With all the talk of dynamic typing, etc. I would have expected so, but now I wonder... Thanks, Ryan _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
