>> 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.
Hmm, I'd not have guessed. Thanks - I have learnt something new today :o)
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
