how to: refer to select list calculations other places in the calculations.

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: Raw Message | Whole Thread | 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/>

Responses

Browse pgsql-sql by date

  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