Re: Can't use WITH in a PERFORM query in PL/pgSQL?

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: depstein(at)alliedtesting(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org, pgagarinov(at)alliedtesting(dot)com, vshahov(at)alliedtesting(dot)com
Subject: Re: Can't use WITH in a PERFORM query in PL/pgSQL?
Date: 2011-03-24 15:36:31
Message-ID: AANLkTikWLLC4hzenTCkNc-v4CMoBYB33yiSb_va6oX8c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello

why you can do it?

please, try to RETURN QUERY ...

Regards

Pavel Stehule

>
> $$begin
>
> perform(
>
> with A as (select generate_series(1,3) as foo)
>
> select foo from A
>
> );
>
> end$$;
>
>

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Nathan M. Davalos 2011-03-24 15:48:49 Re: BUG #5944: COPY FROM doesn't work with international characters
Previous Message depstein 2011-03-24 15:21:36 Re: Can't use WITH in a PERFORM query in PL/pgSQL?