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

Поиск
Список
Период
Сортировка
От Bernd.Nawothnig@t-online.de (Bernd Nawothnig)
Тема Re: how to: refer to select list calculations other places in the calculations.
Дата
Msg-id 20091031211106.GA9238@miraculix
обсуждение исходный текст
Ответ на how to: refer to select list calculations other places in the calculations.  ("Little, Douglas" <DOUGLAS.LITTLE@orbitz.com>)
Ответы Re: how to: refer to select list calculations other places in the calculations.  (the6campbells <the6campbells@gmail.com>)
Список 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

В списке pgsql-sql по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Foreign key columns
Следующее
От: cholid
Дата:
Сообщение: Database connection error, try to reset the connection parameters