Dear all, this might be a stupid question, but do I have to use single or double quotes when defining an alias?
SELECT column1 AS 'c' --or-- SELECT column2 AS "d" On the one hand, the name refers to a column or table identifier. On the other hand, at the time of using this statement, the identifier does not exist yet. At that moment, it is a string literal telling that an identifier with that name should be created. So which one is correct? _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users