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

but I want as a separate columns, like a normal SELECT ...


this is what I get:

+---------------+
| row           |
+---------------+
| (1,"ref rai") |
| (1,ref)       |
+---------------+


thanks,


raimon


On 05/07/2007, at 21:30, Tom Lane wrote:

> 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
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>