I want to do this:
SELECT a, (select x,y,z from table2 where table1.a = table2.w), b, cfrom table1;
But postgres complains:
ERROR: Subselect must have only one field
How can I get around this?