What should be the results of this little test:

drop table t1;
drop table t2;
create table t1 (a int, b int);
create table t2 (a int, c int);
insert into t1(a, b) VALUES (1, 1); 
insert into t1(a, b) VALUES (1, 2); 
insert into t1(a, b) VALUES (1, 3); 
insert into t1(a, b) VALUES (1, 4); 
insert into t1(a, b) VALUES (2, 1);   
insert into t1(a, b) VALUES (2, 2); 
insert into t1(a, b) VALUES (2, 3); 
insert into t1(a, b) VALUES (3, 1);  
insert into t1(a, b) VALUES (3, 2); 
select * from t1;
insert into t2 (a, c) select distinct a, 0 from t1;   
select * from t2;
update t2 set c = c+b from t1 where t1.a=t2.a;
select * from t2;

My guess would be:
a|c
-+--
1|10
2|6
3|3
(3 rows)
How does the standard address this?

Wed, 10 Feb 1999 13:45:53 -0600
"Jackson, DeJuan" <djackson@cpsgroup.com>
Possible bug on update