On Feb 18, 2010, at 5:52 PM, 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.

That explains it.  Thanks.  Breaks the rule of least surprise, but it is SQL.

eric
-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to