From: | Rob Sargent <robjsargent(at)gmail(dot)com> |
---|---|
To: | "Little, Douglas" <DOUGLAS(dot)LITTLE(at)orbitz(dot)com>, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: how to: refer to select list calculations other places in the calculations. |
Date: | 2009-09-10 16:32:40 |
Message-ID: | 4AA92A28.1060902@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
I might do the substitution, analyse the query and hope to break it up.
Can it possibly be optimal?
Little, Douglas wrote:
> Hi Rob,
> Thanks for the response.
> Repeating the base calculation will work but the calculations are stunningly complex and long. Repeating them will undoubtly increase editing errors and maintenance problems.
>
> Wish I had a sample to post. Last query I analyzed was approx 10k lines and printed to over 50 pages. Yes, it was a single query. I'm amazed that cognos would generate. Basically they generate a pivoted cross-tab from sql.
>
> Thanks
> Doug
>
>
>
>
> -----Original Message-----
> From: Rob Sargent [mailto:robjsargent(at)gmail(dot)com]
> Sent: Wednesday, September 09, 2009 11:59 PM
> To: Little, Douglas
> Subject: Re: [SQL] how to: refer to select list calculations other places in the calculations.
>
> Would reverting to the base columns work?
>
> select a, b, a+b as c, (a+b)*d, (a+b)*f etc.
>
> Little, Douglas wrote:
>
>> Hi,
>>
>> I have very complex sql (generated by cognos) I'm porting from
>> Teradata that basically uses column alias in the calculated columns.
>>
>> Is there any way to do this type of thing in Psql?
>>
>> Essentially I need to do is refer to a calculated column later in the
>> select list (but far more complex - like 50 pages printed out)
>>
>> sel a,b,a+b as c, c*d, c*f, c*g, c*h, c*I, c*j, c*k,...... --- where c is
>> a calculated column used in other calculations.
>>
>> from ....
>>
>> **Doug Little**
>>
>> Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz
>> Worldwide
>>
>> 500 W. Madison, Suite 1000 Chicago IL 60661| Office 312.260.2588 | Fax
>> 312.894.5164 | Cell 847-997-5741
>>
>>
>> ***Douglas(dot)Little(at)orbitz(dot)com* <mailto:Douglas(dot)Little(at)orbitz(dot)com>**__
>>
>> orbitz.com <http://www.orbitz.com/> | ebookers.com
>> <http://www.ebookers.com/> | hotelclub.com <http://www.hotelclub.com/>
>> | cheaptickets.com <http://www.cheaptickets.com/> | ratestogo.com
>> <http://www.ratestogo.com/> | asiahotels.com <http://www.asiahotels.com/>
>>
>>
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2009-09-11 07:26:17 | Re: Encryption in the tables of a Postgres 7.3.2 database |
Previous Message | Mario Splivalo | 2009-09-10 14:13:22 | Re: Trapping 'invalid input syntax for integer' |