Postgres Pro
Downloads
Home   >   mailing lists

Re: Can't use WITH in a PERFORM query in PL/pgSQL? - Mailing list pgsql-bugs

From Pavel Stehule
Subject Re: Can't use WITH in a PERFORM query in PL/pgSQL?
Date
Msg-id AANLkTikWLLC4hzenTCkNc-v4CMoBYB33yiSb_va6oX8c@mail.gmail.com
Whole thread Raw
In response to Re: Can't use WITH in a PERFORM query in PL/pgSQL?  (<depstein@alliedtesting.com>)
Responses Re: Can't use WITH in a PERFORM query in PL/pgSQL?
List pgsql-bugs
Tree view 
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$$;
>
>

pgsql-bugs by date:

Previous
From:
Date:
Subject: Re: Can't use WITH in a PERFORM query in PL/pgSQL?
Next
From: "Nathan M. Davalos"
Date:
Subject: Re: BUG #5944: COPY FROM doesn't work with international characters