Re: is any reason why only one columns subselect are allowed in array()?

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: is any reason why only one columns subselect are allowed in array()?
Дата
Msg-id 603c8f070811180729m7360b8b8k737a6936007a64bf@mail.gmail.com
обсуждение исходный текст
Ответ на is any reason why only one columns subselect are allowed in array()?  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Ответы Re: is any reason why only one columns subselect are allowed in array()?  (David Fetter <david@fetter.org>)
Список pgsql-hackers
Дерево обсуждения 
On Tue, Nov 18, 2008 at 10:06 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> Hello
>
> I am thinking about allowing 2D array from multicolumn subselect (all
> columns have to share same type, ofcourse). Is there some real limit,
> why this functionality is disallowed?

Seems like you could just write SELECT ARRAY[col1, col2, col3] instead
of SELECT col1, col2, col3.

...Robert

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

Предыдущее
От: Zdenek Kotala
Дата:
Сообщение: Re: toast by chunk-end (was Re: PG_PAGE_LAYOUT_VERSION 5 - time for change)
Следующее
От: David Fetter
Дата:
Сообщение: Re: TABLE command