Re: [sqlite] Comparison of numbers as text

>> Can someone explain what is going on in the third select statement >> below? I would have expected it to return a row because the number is >> quoted. >> >> sqlite> select 'foo' where 1 in (1, '2', 'three'); >> foo >> sqlite> select 'foo' where 2 in (1, '2', 'three'); >> sqlite> select 'foo'

[sqlite] Comparison of numbers as text

Can someone explain what is going on in the third select statement below? I would have expected it to return a row because the number is quoted. sqlite> select 'foo' where 1 in (1, '2', 'three'); foo sqlite> select 'foo' where 2 in (1, '2', 'three'); sqlite> select 'foo' where '2' in (1, '2',