| From: | Pál Teleki <ellenallhatatlan(at)gmail(dot)com> |
|---|---|
| To: | |
| Cc: | pgsql-novice novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: 2nd attempt: Window function SQL - can't quite figure it. |
| Date: | 2016-07-19 01:21:14 |
| Message-ID: | CAMLfE0PiSoA6eEF6sEF-Q33phP43kh7gcqT+1PFcu1-nRu1Rag@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
>> Now, why can't I use deptot and stot_per_man aliases in my query? It
>> would greatly simplify the SQL by removing the need for a subquery (or inline
>> view as Oracle calls them).
> SQL execution of a query is only done once. Referring to an alias at the
> same level in a query would require some kind of duplication to work.
> Either two phase processing or cloning the subselect that is being alised
> and executing it a second time to be used in the second location. Neither
> are desirable.
Thanks for the assistance and clarification. Appreciate your time!
Pál
> David J.
--
--
Pál Teleki
| From | Date | Subject | |
|---|---|---|---|
| Next Message | KARIN SUSANNE HILBERT | 2016-07-20 19:37:49 | PostgreSQL v9.4, ERROR: must be owner of database test_db |
| Previous Message | David G. Johnston | 2016-07-18 23:18:35 | Re: 2nd attempt: Window function SQL - can't quite figure it. |