On Fri, Jul 26, 2002 at 03:14:37PM +0200, Janning Vygen wrote:
>
> UPDATE real
> SET val1=(SELECT val1 FROM temp WHERE temp.id = real.id ),
> val2=(SELECT val2 FROM temp WHERE temp.id = real.id )
> WHERE id IN (SELECT temp.id FROM temp);
Ick. IN is a well-known dog in Postgres. Try this:
UPDATE real
SET val1=temp.val1,val2=temp.val2
WHERE id=temp.id;
A
--
----
Andrew Sullivan 87 Mowat Avenue
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110