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

Hi,


It's not possible to return in a subquery more than one column ?

SELECT id_intern, (SELECT referencia, descripcio FROM articles WHERE
id_intern = product_blister.id_product_added) FROM product_blister
WHERE id_product_source = '8';


so, I would have to add a new subquery for each column I want to
retrieve ?


like this:

SELECT id_intern, (SELECT referencia FROM articles WHERE id_intern =
product_blister.id_product_added),(SELECT descripcio FROM articles
WHERE id_intern = product_blister.id_product_added) FROM
product_blister  WHERE id_product_source = '8';


all of them are from the same table ...


regards,


raimon fernandez