Monday, December 09, 2019, 7:25:25 AM, Clemens Ladisch <clem...@ladisch.de> wrote:
> The SQL-92 standard actually says: > > | Syntax Rules > | > | 9) Case: > | > | b) If the i-th <derived column> in the <select list> does not > | specify an <as clause> and the <value expression> of that > | <derived column> is a single <column reference>, then the > | <column name> of the i-th column of the result is C. > | Presumably the third line of clause (b) of the standard SHOULD have read: "is a single <column reference> C,", otherwise "is C" has nothing to refer to. Graham (And it's not a transcription error, according to: https://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
