How to update

From: Andre Schubert <andre(dot)schubert(at)km3(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: How to update
Date: 2002-06-03 08:00:28
Message-ID: 20020603100028.38dd8a7e.andre.schubert@km3.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all,

i have a simple problem with an sql-update.
Lets say i have a table foo which contains a
ip::inet and to counters inet and local.
And i have a table bar which contains
ip::inet inet and local.

I need these two tables for traffic-accounting.
The table foo should contain the sum of traffic of bar,
therefore once a month i would like to run a script which
performs a query that
selects sum(inet),sum(local) from bar
and
updates foo with these two values where bar.ip = foo.ip.

Who can explain how to perform this action with one query.
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;

Thanks in advance

P.S.: Sorry for my bad english, hope you understand what i mean :)

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Manfred Koizar 2002-06-03 13:08:46 Re: How to update
Previous Message russm 2002-06-03 06:45:36 Re: alternate idioms for large "IN (...)" lists