Dne 25. 10. 19 v 23:55 Thomas Kurz napsal(a) > 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?
I was bit surprised that sqlite accepts also AS 'c' (other DBMS do not). But the standard way is AS "d" – it is an identifier. It is like if you are defining a variable in a programming language – the variable with this name does not exist yet, but same rules apply for the name syntax. Franta _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
