[GENERAL] WITH x AS (...) and visibility in UPDATE

2011-07-27 Thread Peter V
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 titl

Re: [GENERAL] WITH x AS (...) and visibility in UPDATE

2011-07-27 Thread Peter V
> Date: Wed, 27 Jul 2011 15:58:04 -0500 > Subject: Re: [GENERAL] WITH x AS (...) and visibility in UPDATE > From: mmonc...@gmail.com > To: peterv861...@hotmail.com > CC: pgsql-general@postgresql.org > > On Wed, Jul 27, 2011 at 3:

Re: [GENERAL] WITH x AS (...) and visibility in UPDATE

2011-07-27 Thread Peter V
> Date: Wed, 27 Jul 2011 16:16:48 -0500 > Subject: Re: [GENERAL] WITH x AS (...) and visibility in UPDATE > From: mmonc...@gmail.com > To: peterv861...@hotmail.com > CC: pgsql-general@postgresql.org > > On Wed, Jul 27, 2011 at 4: