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

From: Bernd(dot)Nawothnig(at)t-online(dot)de (Bernd Nawothnig)
To: "Little, Douglas" <DOUGLAS(dot)LITTLE(at)orbitz(dot)com>
Cc: "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-10-31 21:11:06
Message-ID: 20091031211106.GA9238@miraculix
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Scott Marlowe 2009-11-01 00:08:06 Re: Speed up UPDATE query?
Previous Message Thomas Kellerer 2009-10-30 23:46:50 Re: pg_get_functiondef and overloaded functions