On 1 Nov 2011, at 4:44pm, Pete wrote: > Since SQLite already provides an extension to reference column aliases in > WHERE and JOIN clauses, is there any likelihood that it might be further > extended to allow them in the SELECT statement itself?
That would require processing the SELECT statement before the SELECT statement was processed. For instance, how would you handle this: SELECT (itemPrice * numItems) AS totalPrice, (totalPrice * exchangeRate) AS myCcyPrice FROM invoiceItems; It would change a SELECT command to something which required a great deal of intelligence and code to work out which parts should be done first. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
