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

On Tue, Nov 18, 2008 at 05:19:12PM +0100, Pavel Stehule wrote:
> there are some not necessary limits, because we should some operations:
> 
> postgres=# select array(select * from foo);
> ERROR:  subquery must return only one column
> LINE 1: select array(select * from foo);

The current limitation that a sub-query can only return a single column
is very annoying and is one of the more common restrictions I bump into
when writing SQL.

 Sam