Re: trivial sql help

Patrick Welche wrote:
>  333 |     1
> (18 rows)
>
> 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.

Well, the same query above *does* return more than one row (18 in fact). I
think you need to qualify the sub-select a bit more, but without more details
on your schema, it is hard to guess how.

Joe