Re: RETURN QUERY in PL/PgSQL? - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: RETURN QUERY in PL/PgSQL?
Date
Msg-id 462D2D9F.2020603@dunslane.net
Whole thread Raw
In response to Re: RETURN QUERY in PL/PgSQL?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

Tom Lane wrote:
> Neil Conway <neilc@samurai.com> writes:
>   
>> This works, but it seems overly verbose. It occurred to me that we could
>> easily add a new PL/PgSQL statement that evaluates a set-returning
>> expression and adds *all* the resulting rows to the function's result
>> set. For example:
>>     
>
> I think we've got something isomorphic to that in the patch queue
> already --- take a look at Pavel's "table function" patch.  It's in
> need of cleanup but I think it will make it in.
>
>
>   

Interesting - I haven't followed that one. In pl/perl the equivalent 
will use one tuplestore on the way in and another on the way out, with 
return_next() copying between the two. If we had some mechanism like 
this there is thus a potential for substantial savings, as well as 
improved clarity.

cheers

andrew


pgsql-hackers by date:

Previous
From: usleepless@gmail.com
Date:
Subject: Re: [pgsql-advocacy] Wild idea: 9.0?
Next
From: Peter Eisentraut
Date:
Subject: Re: Better error message for select_common_type()