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