Re: PL/pgSQL PERFORM with CTE - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PL/pgSQL PERFORM with CTE
Date
Msg-id 26176.1377365616@sss.pgh.pa.us
Whole thread Raw
In response to Re: PL/pgSQL PERFORM with CTE  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: PL/pgSQL PERFORM with CTE  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
Pavel Stehule <pavel.stehule@gmail.com> writes:
> Oracle has a special function for returning sets from procedures - see a
> new functionality "Implicit Result Sets"
> http://tkyte.blogspot.cz/2013/07/12c-implicit-result-sets.html

That article is worth reading, because Tom K. points out exactly why
T-SQL's approach is a bad idea compared to returning refcursors.
It's not clear to me that we should be in a hurry to go there, much less
try to be 100% syntax compatible with it.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Marc Cousin
Date:
Subject: Re: Performance problem in PLPgSQL
Next
From: Tom Lane
Date:
Subject: Re: Performance problem in PLPgSQL