On 31 Oct 2018, at 7:14pm, Thomas Kurz <sqlite.2...@t-net.ruhr> wrote:
> may I ask whether there is a deeper reason why using a column alias in the > same SELECT query doesn't work, e.g. > > SELECT column1 AS a, 5*column2 AS b, a+b FROM....... The canonical answer to this is that there's nothing in the SQL specification that says the columns have to be evaluated in left-to-right order. Theoretically a computer which had massive parallelism could fetch the data from the database, then work out all the columns at the same time. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
