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:robjsarg...@gmail.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.lit...@orbitz.com* <mailto:douglas.lit...@orbitz.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/>
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql