Re: PL/pgSQL PERFORM with CTE

2013/8/20 David E. Wheeler <david(at)justatheory(dot)com>

> On Aug 20, 2013, at 2:24 PM, Marko Tiikkaja <marko(at)joh(dot)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
>
>