Re: Referncing a calculated column in a select?

On 9/12/19 2:23 PM, stan wrote:
> I am creating some views, that have columns with fairly complex calculations
> in them. The I want to do further calculations using the result of this
> calculation. Right now, I am just duplicating the first calculation in the
> select fro the 2nd calculated column. There must be a batter way to do
> this, right?

I must be misunderstanding you, because you can just do more of what you're
doing now.

Here's an example of doing some calculations in the creation of the view,
and then more calculations when selecting from the view:

test=# create table gargle (i integer, j integer);
CREATE TABLE

test=# create view v_gargle (i1, j1) as select i*2, j*3 from gargle;
CREATE VIEW

test=# select * from v_gargle;
 i1 | j1
----+----
  4 |  9
(1 row)

test=# select i1 - 3, j1 * 8 from v_gargle;
 ?column? | ?column?
----------+----------
        1 |       72

--
Angular momentum makes the world go 'round.