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

From Marko Tiikkaja
Subject Re: PL/pgSQL PERFORM with CTE
Date
Msg-id 5217C0D4.2000609@joh.to
Whole thread Raw
In response to Re: PL/pgSQL PERFORM with CTE  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
On 2013-08-23 22:02, Josh Berkus wrote:
> On 08/23/2013 11:30 AM, Pavel Stehule wrote:
>> 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
>
> Is there some reason we wouldn't use RETURN QUERY in that case, instead
> of SELECT?  As I said above, it would be more consistent with existing
> PL/pgSQL.

How would using the same syntax to do an entirely different thing be 
consistent?


Regards,
Marko Tiikkaja



pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: PL/pgSQL PERFORM with CTE
Next
From: Josh Berkus
Date:
Subject: Re: PL/pgSQL PERFORM with CTE