wcl...@gfs-hofheim.de wrote: > The following sql is supposedly valid: > > select 1 in (1)'hello';
Apparently this gets interpreted as select (1 in (1)) as "hello"; ("as" is optional), under SQLite's long-standing policy of accepting single and double quotes more or less interchangeably. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users