Re: is any reason why only one columns subselect are allowed in array()? - Mailing list pgsql-hackers

From Robert Haas
Subject Re: is any reason why only one columns subselect are allowed in array()?
Date
Msg-id 603c8f070811180729m7360b8b8k737a6936007a64bf@mail.gmail.com
Whole thread Raw
In response to is any reason why only one columns subselect are allowed in array()?  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Responses Re: is any reason why only one columns subselect are allowed in array()?
List 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 by date:

Previous
From: Zdenek Kotala
Date:
Subject: Re: toast by chunk-end (was Re: PG_PAGE_LAYOUT_VERSION 5 - time for change)
Next
From: David Fetter
Date:
Subject: Re: TABLE command