2013/8/20 David E. Wheeler <da...@justatheory.com> > On Aug 20, 2013, at 2:24 PM, Marko Tiikkaja <ma...@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 Regards Pavel > > Best, > > David > >
