You are quite right, and I must admit that I messed up one more time on this one.
I chose an alias, which was already a column name in one of the relations, so the results were rubbish anyhow.
Took me some time to figure that out.
Von: Vyacheslav Kalinin [mailto:vka@mgcp.com]
Gesendet: Dienstag, 11. Dezember 2007 19:54
An: Stanislav Raskin
Cc: pgsql-general@postgresql.org
Betreff: Re: [GENERAL] Understanding Aliases
> SELECT-list output aliases name the *output* columns of the SELECT.
> Those output columns are not available to the SELECT's computation
> clauses
Then it's unclear how could the first query work