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 :)
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 |