On 6/28/09, Tim Largy <tim.la...@gmail.com> wrote: > 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', 'three'); > sqlite> select 'foo' where 'three' in (1, '2', 'three'); > foo >
dunno... works fine for me [09:57 PM] ~$sqlite3 SQLite version 3.6.11 Enter ".help" for instructions Enter SQL statements terminated with a ";" 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', 'three'); foo sqlite> select 'foo' where 'three' in (1, '2', 'three'); foo sqlite> -- Puneet Kishor http://www.punkish.org/ Carbon Model http://carbonmodel.org/ Charter Member, Open Source Geospatial Foundation http://www.osgeo.org/ Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor/ Nelson Institute, UW-Madison http://www.nelson.wisc.edu/ ----------------------------------------------------------------------- "assertions are politics... backing up assertions with evidence is science" ======================================================================= _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
