Message-ID: <3EF2A496.40505@klaster.net>
Date: Fri, 20 Jun 2003 08:07:18 +0200
From: Tomasz Myrta <jasiek@klaster.net>
User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; en-US;
	rv:1.4b) Gecko/20030507
MIME-Version: 1.0
To: =?ISO-8859-2?Q?Egy=FCd_Csaba?= <csegyud@freemail.hu>
Cc: pgsql-sql@postgresql.org
Subject: Re: Getting one row for each subquery row...?
References: <007901c336ea$9cee0e80$230a0a0a@compaq>
In-Reply-To: <007901c336ea$9cee0e80$230a0a0a@compaq>
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Content-Transfer-Encoding: 8bit

Dnia 2003-06-20 07:12, Użytkownik Együd Csaba napisał:
> Hi All,
>  here are my three tables. I wold like to list them in the following way: I
>  need all the columns from t_stockchanges, and one field for the
> productgroup
>  the t_stockchanges.productid belongs to.
> 
>  But one product can belong to many groups, so i would need one row for each
>  group for each product.
> 
>  My bad query is:
>  ------------------------
>  DB=# select t_stockchanges.productid, (select name from t_productgroups
>  where id=(select productgroupid from t_prod_in_pgr where
>  productid=t_stockchanges.productid)) as pgroup from t_stockchanges;
>  ERROR:  More than one tuple returned by a subselect used as an expression.
>  DB=#
>  ---------------
>  Yes, this is absolutelly true, but I would like postgres to give me all the
>  tuples found. How can I ask him to do so?
> 
>  Thank you,
>  -- Csaba
> 
Sure, use "limit 1" in a subquery.

"limit" and "offset" are well described in Postgresql documentation.

Regards,
Tomasz Myrta