Postgres Pro
Downloads
Home   >   mailing lists

Re: subquery with more than one column - Mailing list pgsql-novice

From Tom Lane
Subject Re: subquery with more than one column
Date
Msg-id 20860.1183663833@sss.pgh.pa.us
Whole thread Raw
In response to subquery with more than one column  (Raimon Fernandez <coder@montx.com>)
Responses Re: subquery with more than one column
List pgsql-novice
Tree view 
Raimon Fernandez <coder@montx.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

pgsql-novice by date:

Previous
From: Raimon Fernandez
Date:
Subject: subquery with more than one column
Next
From: "s anwar"
Date:
Subject: Re: Postgres not using indices defined on my table with certain queries using "in"