Re: PL/pgSQL PERFORM with CTE

From: "David E(dot) Wheeler" <david(at)justatheory(dot)com>
To: Marko Tiikkaja <marko(at)joh(dot)to>
Cc: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, pgsql-hackers Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PL/pgSQL PERFORM with CTE
Date: 2013-08-20 12:30:47
Message-ID: 4DB06DE7-B5D8-4059-938C-12BBAB4F50FB@justatheory.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Best,

David

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2013-08-20 12:31:38 Re: PL/pgSQL PERFORM with CTE
Previous Message Andres Freund 2013-08-20 12:25:39 Re: PL/pgSQL PERFORM with CTE