That's not what I said, why don't you read/quote the whole sentence: "Besides being part of the standard (I assume), what's the rationale for this restriction?"
I'm asking why the SQL standard restricts the use of aliases in this way and what the benefit of this restriction is. On Sat, Sep 5, 2015 at 8:49 AM, Simon Slavin <slavins at bigfraud.org> wrote: > > On 5 Sep 2015, at 3:19pm, Darko Volaric <lists at darko.org> wrote: > > > Besides being part of the standard (I assume) > > You assume incorrectly. In the classic SQL model, aliases to column names > are assigned after the results have been returned. In other words, aliases > cannot be used in the WHERE clause. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
