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