Re: PL/pgSQL PERFORM with CTE

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).

Best,

David