On Thu, 10 Oct 2002, Patrick Welche wrote:
> update rawrequest
> set cid=(select pc.c
> from pers_comp as pc
> where pc.p=pid
> group by pc.c
> having count(pc.c)=1
> )
> where pr
> ;
>
> ERROR: More than one tuple returned by a subselect used as an expression.
>
> pid, pc.p, pc.c, cid are all integers. pc just has 2 columns p and c.
>
> I thought putting the count()=1 in there would force a single tuple..
No, that'll limit you only to groups having a count of 1. It'll still
give multiple groups. You could probably use limit to get 1 row, but
what's the actual behavior you want the update to have?