> You cannot access new values of a particular row within a single UPDATE
> statement, but you do see new values done in the same transaction.
> This is explain in some detail in the documentation:
>
> http://www.postgresql.org/docs/8.4/interactive/transaction-iso.html#XACT-READ-COMMITTED
I tried
drop table if exists tt ;
create temp table tt ( a int, b int );
insert into tt values ( 1,2);
insert into tt values ( 3,4);
update tt set a=a*10, b=(select sum(a) from tt);
select * from tt
b has value 4 for every row.
So we *dont* see new values done in the same transaction.
How to fix ?
Andrus.