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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
