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:[EMAIL PROTECTED] 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
