How to update
От | Andre Schubert |
---|---|
Тема | How to update |
Дата | |
Msg-id | 20020603100028.38dd8a7e.andre.schubert@km3.de обсуждение исходный текст |
Ответы |
Re: How to update
|
Список | 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 :)
В списке pgsql-sql по дате отправления: