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.
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
