Scott Bailey wrote:
SQL name resolution rules are that column names have higher precedence than aliases and variables. So it will always bind to the column not the alias.
Eric B. Ridge wrote:
That explains it. Thanks. Breaks the rule of least surprise, but it is SQL.
I don't think it does break the rule of least surprise. How would one expect the column or the alias to have precedence without knowledge of the rule from documentation? The only thing I would expect if I were unaware of the rule is that there might be a conflict and that I'd have to look up the precedence.
-- Lew -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
