[pgpool-hackers: 1042] Re: WITH clause in INSERT/UPDATE in replication mode

[Yugo Nagata]

Hi,

sorry for some typos.


>  CREATE TABLE test (t timestamp default now());
> 
>  WITH v AS (now() AS t)
>  UPDATE test SET t = default
>  FROM v
>  WHERE test.v < v.t;
           ^^^^^^^ test.t


-- 
Yugo Nagata <nagata at sraoss.co.jp>