From: | "Little, Douglas" <DOUGLAS(dot)LITTLE(at)orbitz(dot)com> |
---|---|
To: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
Subject: | how to: refer to select list calculations other places in the calculations. |
Date: | 2009-09-09 13:27:35 |
Message-ID: | A434C531E37AD442815608A769550D80590432A1BC@EGEXCMB01.oww.root.lcl |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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>
[cid:image002(dot)jpg(at)01CA3127(dot)61E69F30] 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-09 14:35:35 | Re: trigger failed to identify the partions |
Previous Message | Oliveiros C, | 2009-09-09 11:10:29 | Differences between bit string constant sintax |