Re: subquery with more than one column

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Raimon Fernandez <coder(at)montx(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: subquery with more than one column
Date: 2007-07-05 19:30:33
Message-ID: 20860.1183663833@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Raimon Fernandez <coder(at)montx(dot)com> writes:
> It's not possible to return in a subquery more than one column ?

Try it like this:

SELECT id_intern, (SELECT ROW(referencia, descripcio) FROM articles WHERE...

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message s anwar 2007-07-05 19:59:17 Re: Postgres not using indices defined on my table with certain queries using "in"
Previous Message Raimon Fernandez 2007-07-05 18:34:25 subquery with more than one column