Re: Alias name from subquery

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Alias name from subquery
Дата
Msg-id dcc563d10809300910j4497613cy391b6368bd09433c@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Alias name from subquery  (Felix Homann <fexpop@onlinehome.de>)
Ответы Re: Alias name from subquery  ("Dot Yet" <dot.yet@gmail.com>)
Список pgsql-general
On Tue, Sep 30, 2008 at 8:29 AM, Felix Homann <fexpop@onlinehome.de> wrote:

> _But_, I don't want to give the alias explicitely, instead it should be
> taken from a second table 'colnames', i.e. something like the line I sent in
> my initial mail. Any idea?

Then you'll have to build a query in plpgsql and execute it to get
what you want.  You can't do what you're trying to do in normal SQL.
At least I don't think it's possible.

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

Предыдущее
От: Sam Mason
Дата:
Сообщение: Re: Alias name from subquery
Следующее
От: "Dot Yet"
Дата:
Сообщение: Re: Alias name from subquery