Re: Referncing a calculated column in a select?

2019-09-13 Thread Peter J. Holzer
On 2019-09-13 11:49:28 +0900, Kyotaro Horiguchi wrote: > At Thu, 12 Sep 2019 23:16:01 +0200, "Peter J. Holzer" > wrote in <20190912211601.ga3...@hjp.at> > > On 2019-09-12 15:35:56 -0500, Ron wrote: > > > On 9/12/19 2:23 PM, stan wrote: > > > > I am creating some views, that have columns with fair

Re: Referncing a calculated column in a select?

2019-09-12 Thread Kyotaro Horiguchi
Hello. At Thu, 12 Sep 2019 23:16:01 +0200, "Peter J. Holzer" wrote in <20190912211601.ga3...@hjp.at> > On 2019-09-12 15:35:56 -0500, Ron wrote: > > 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

Re: Referncing a calculated column in a select?

2019-09-12 Thread Peter J. Holzer
On 2019-09-12 15:35:56 -0500, Ron wrote: > 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 calcula

Re: Referncing a calculated column in a select?

2019-09-12 Thread Ron
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. The

Referncing a calculated column in a select?

2019-09-12 Thread stan
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 th