two fields in subselect - Mailing list pgsql-sql

From Joseph Shraibman
Subject two fields in subselect
Date
Msg-id 392B0BFC.BB2CD23B@selectacast.net
Whole thread Raw
Responses Re: two fields in subselect  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
I want to do this:

SELECT a, (select x,y,z from table2 where table1.a = table2.w), b, c
from table1;

But postgres complains:

ERROR:  Subselect must have only one field


How can I get around this?



pgsql-sql by date:

Previous
From: "Steffers"
Date:
Subject: Functions and Variables.
Next
From: Tom Lane
Date:
Subject: Re: two fields in subselect