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

From Merlin Moncure
Subject Re: Can't use WITH in a PERFORM query in PL/pgSQL?
Date
Msg-id CAHyXU0yw0FA58Z5yWJ2uTKTOXGDTRFj32fj=xrfXYuy8GahjVA@mail.gmail.com
Whole thread Raw
In response to Re: Can't use WITH in a PERFORM query in PL/pgSQL?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Thu, Oct 20, 2011 at 3:01 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Pavel Stehule <pavel.stehule@gmail.com> writes:
>> I didn't design a PERFORM statement. There is two views - somebody
>> from sybase's family know so SELECT without into is forwarded to
>> client. This functionality is missing on Oracle's family. Is true so
>> PERFORM statement is strange, =A0but maybe it's open door for sybase's
>> functionality that was not implemented ever.
>
> I cannot imagine that we'd ever make SELECT inside a plpgsql function
> act like that. =A0Functions have no business directly transmitting
> information to the client; if they tried, they'd most likely just break
> the FE/BE protocol.
>
> There might be use for such a thing in a hypothetical "real stored
> procedure language" where the code is executing in a context entirely
> different from what Postgres functions run in ... but that language
> would be something different from plpgsql.

small aside: I disagreed with this point a while back but I'm coming
around to your point of view...

merlin

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Can't use WITH in a PERFORM query in PL/pgSQL?
Next
From: Pavel Stehule
Date:
Subject: Re: Can't use WITH in a PERFORM query in PL/pgSQL?