On Aug 20, 2013, at 2:24 PM, Marko Tiikkaja <marko@joh.to> wrote:
>> postgres=# DO $$ >> BEGIN >> PERFORM * FROM (WITH now AS (SELECT now()) >> SELECT * from now) x; >> END; >> $$; >> DO > > .. which doesn't work if you want to use table-modifying CTEs.
Which, in fact, is exactly my use case (though not what I posted upthread).
but it works
postgres=# do $$begin with x as (select 10) insert into omega select * from x; end;$$; DO