Re: Alias name from subquery

Поиск
Список
Период
Сортировка
От Sam Mason
Тема Re: Alias name from subquery
Дата
Msg-id 20080930152355.GO7271@frubble.xen.chris-lamb.co.uk
обсуждение исходный текст
Ответ на Alias name from subquery  (Felix Homann <fexpop@onlinehome.de>)
Ответы Re: Alias name from subquery
Список pgsql-general
On Tue, Sep 30, 2008 at 03:21:53PM +0200, Felix Homann wrote:
> I would like to set an alias name for a column from a subquery, i.e.
> something like this:
>
> SELECT entry AS (SELECT name from colnames WHERE id=1) from entries ;
>
> Obviously it doesn't work _this_ way, but is there _any_ way to do it?

Generate the SQL correctly in the first place? :)

I think you may be trying to solve the wrong problem, what are you
really trying to do?


  Sam

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

Предыдущее
От: Felix Homann
Дата:
Сообщение: Re: Alias name from subquery
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Alias name from subquery