On May 19, 2011, at 12:28 AM, Igor Tandetnik wrote: > That's SQLite extension. I don't believe it's legal standard SQL. The > alias in the SELECT clause acts kind of like a macro; its use in the > rest of the statement is simply replaced with the corresponding expression.
Mind-boggling. Border line insane :) > The query could be written without using this feature, but it wouldn't > be quite as neat and readable. Neat indeed. Well played :)) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users