[sqlite] text/numeric comparison confusion

[Jeffrey Mattox]

When used in a SELECT, I expect this comparison to be true (and it is):
   ( cast('25' as INTEGER) = 25 )  <--- true

But, why is this false:
   ( '25' = 25 )  <--- false?

and this is true:
   ( cast(25 as TEXT) = 25 )  <--- true

So, being that second comparison is false (why?), then why isn't the third 
comparison also false?



_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users