Re: How to update - Mailing list pgsql-sql

On Mon, 3 Jun 2002 10:00:28 +0200, Andre Schubert
<andre.schubert@km3.de> wrote:
>I tried this, but it update always one row in foo.
>
>update foo set inet=sum(bar.inet),local=sum(bar.local) where foo.ip = bar.ip;

Andre,
this worked in my test:

UPDATE foo  SET inet=b.i, local=b.l FROM (SELECT ip, sum(inet) AS i, sum(local) AS l         FROM bar       GROUP BY
ip)bWHERE foo.ip = b.ip;
 

ServusManfred