Hello all,
I am trying out PostgreSQL 9.1 Beta 3. In particular, I am very interested in WITH x AS (...) construction.
drop table if exists t;
create table t
(
identifier serial,
title text
);
with c as
(
insert into t (title) values ('old') returning *
)
update t set title = 'new' from c where t.identifier = c.identifier;
select * from t;
Can someone explain why this returns 'old' instead of 'new'? Is the new row not yet visible when the update is
evaluated?
Thanks.