I want to do this:
SELECT a, (select x,y,z from table2 where table1.a = table2.w), b, c
But postgres complains:
ERROR: Subselect must have only one field
How can I get around this?
Next:From: Tom LaneDate: 2000-05-23 23:32:32
Subject: Re: two fields in subselect
Previous:From: SteffersDate: 2000-05-23 21:16:01
Subject: Functions and Variables.