see http://sqlfiddle.com/#!15/e30d9/8/0 for schema and sql. http://stackoverflow.com/questions/12238621/sql-subquery-has-too-many-columns -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general