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

From: "Robert Haas" <robertmhaas(at)gmail(dot)com>
To: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
Cc: "postgres hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: is any reason why only one columns subselect are allowed in array()?
Date: 2008-11-18 15:29:53
Message-ID: 603c8f070811180729m7360b8b8k737a6936007a64bf@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Nov 18, 2008 at 10:06 AM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2008-11-18 15:31:31 Re: Re: toast by chunk-end (was Re: PG_PAGE_LAYOUT_VERSION 5 - time for change)
Previous Message Zdenek Kotala 2008-11-18 15:24:44 Re: toast by chunk-end (was Re: PG_PAGE_LAYOUT_VERSION 5 - time for change)