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

From Pavel Stehule
Subject Re: PL/pgSQL PERFORM with CTE
Date
Msg-id CAFj8pRDvNBMm5kg4rs3yjHz2ZpxrN0j8VhqA_AOFA=YuFOzJLQ@mail.gmail.com
Whole thread Raw
In response to Re: PL/pgSQL PERFORM with CTE  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers



2013/8/23 Josh Berkus <josh@agliodbs.com>
Pavel,

> But it can have a different reason. In T-SQL (Microsoft or Sybase) or MySQL
> a unbound query is used to direct transfer data to client side.

Are you planning to implement that in PL/pgSQL?


yes. I would to see a stored procedures with this functionality in pg

 
Currently, PL/pgSQL requires RETURN ____ in order to return a query
result to the caller.  Is there some reason we'd change that?


it is different functionality.
 
If you're implementing TSQL-for-PostgreSQL, of course you might want to
have different behavior with SELECT.  However, TSQL is not PL/pgSQL.

I don't would to implement T-SQL. Same functionality has a PSM in MySQL. And in this moment, there is not any blocker why this should not be in Postgres.
 
Regards

Pavel


--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: A note about bug #8393
Next
From: Pavel Stehule
Date:
Subject: Re: PL/pgSQL PERFORM with CTE