On Fri, 25 Oct 2019 23:55:20 +0200 Thomas Kurz <sqlite.2...@t-net.ruhr> wrote:
> SELECT column1 AS 'c' > --or-- > SELECT column2 AS "d" > > On the one hand, the name refers to a column or table identifier. The SQL-92 standard refers to that kind of name as a "correlation name", and its BNF grammar designates a correlation name as a kind of indentifier. Therefore, syntactically, "d" is correct because double-quotes are used to quote identifiers. Which was news to me. I've always used single-quotes for correlation names (on creation, never reference). Not because they need quoting. I never choose a correlation name that needs to be quoted; normally they're just 3 lower-case letters, at most. I would quote them only to make them stand out for the syntax highlighter. And who doesn't like pretty SQL? --jkl _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
