Re: Understanding Aliases

["Stanislav Raskin" <sr@xxxxxxxxxxxxx>]

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@xxxxxxxx]
Gesendet: Dienstag, 11. Dezember 2007 19:54
An: Stanislav Raskin
Cc: pgsql-general@xxxxxxxxxxxxxx
Betreff: Re: 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