Postgres Pro
Downloads
Home   >   mailing lists

Re: how to: refer to select list calculations other places in the calculations. - Mailing list pgsql-sql

From Bernd.Nawothnig@t-online.de (Bernd Nawothnig)
Subject Re: how to: refer to select list calculations other places in the calculations.
Date
Msg-id 20091031211106.GA9238@miraculix
Whole thread Raw
In response to how to: refer to select list calculations other places in the calculations.  ("Little, Douglas" <DOUGLAS.LITTLE@orbitz.com>)
Responses Re: how to: refer to select list calculations other places in the calculations.  (the6campbells <the6campbells@gmail.com>)
List pgsql-sql
Tree view 
On Wed, Sep 09, 2009 at 08:27:35AM -0500, Little, Douglas wrote:

> 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?

I use nested subqueries and do the renaming of calculated columns in the
innermost queries in such cases.




Bernd

pgsql-sql by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Foreign key columns
Next
From: cholid
Date:
Subject: Database connection error, try to reset the connection parameters