From: Bernd.Nawothnig@t-online.de
To: Little, Douglas <DOUGLAS.LITTLE@orbitz.com>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: how to: refer to select list calculations other places in the calculations.
Date: Sat, 31 Oct 2009 22:11:06 +0100
Message-ID: <20091031211106.GA9238@miraculix> (raw)
In-Reply-To: <A434C531E37AD442815608A769550D80590432A1BC@EGEXCMB01.oww.root.lcl>
References: <A434C531E37AD442815608A769550D80590432A1BC@EGEXCMB01.oww.root.lcl>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Bernd.Nawothnig@t-online.de, DOUGLAS.LITTLE@orbitz.com
Subject: Re: how to: refer to select list calculations other places in the calculations.
In-Reply-To: <20091031211106.GA9238@miraculix>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox