| From: | "Stanislav Raskin" <sr(at)brainswell(dot)de> |
|---|---|
| To: | "'Vyacheslav Kalinin'" <vka(at)mgcp(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Understanding Aliases |
| Date: | 2007-12-11 18:55:57 |
| Message-ID: | E1J2AGx-0005tQ-00@teena.zerebecki.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)mgcp(dot)com]
Gesendet: Dienstag, 11. Dezember 2007 19:54
An: Stanislav Raskin
Cc: pgsql-general(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Collin Kidder | 2007-12-11 19:01:41 | Re: top posting |
| Previous Message | Vyacheslav Kalinin | 2007-12-11 18:53:59 | Re: Understanding Aliases |