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

On Tue, Nov 18, 2008 at 10:29:53AM -0500, Robert Haas wrote:
> 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.

If I understand this right, Pavel is thinking that
   ARRAY(SELECT col1, col2, col3...)

should produce an array each element of which is the compound type
consisting of (col1, col2, col3), and if it doesn't produce one, we're
looking at a pretty large POLA violation.

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate