Postgres Pro
Downloads
Home   >   mailing lists

Re: 2nd attempt: Window function SQL - can't quite figure it. - Mailing list pgsql-novice

From David G. Johnston
Subject Re: 2nd attempt: Window function SQL - can't quite figure it.
Date
Msg-id CAKFQuwbfsy+2Z8WQXn6nyDQVpADwYje7LvAg5pWrP-R9t5OhnQ@mail.gmail.com
Whole thread Raw
In response to Re: 2nd attempt: Window function SQL - can't quite figure it.  (Pál Teleki <ellenallhatatlan@gmail.com>)
Responses Re: 2nd attempt: Window function SQL - can't quite figure it.
List pgsql-novice
Tree view
On Monday, July 18, 2016, Pál Teleki <ellenallhatatlan@gmail.com> wrote:
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.

David J.

pgsql-novice by date:

Previous
From: Pál Teleki
Date:
Subject: Re: 2nd attempt: Window function SQL - can't quite figure it.
Next
From: Pál Teleki
Date:
Subject: Re: 2nd attempt: Window function SQL - can't quite figure it.