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

From Tom Lane
Subject Re: RETURN QUERY in PL/PgSQL?
Date
Msg-id 13967.1177364937@sss.pgh.pa.us
Whole thread Raw
In response to RETURN QUERY in PL/PgSQL?  (Neil Conway <neilc@samurai.com>)
Responses Re: RETURN QUERY in PL/PgSQL?  (Andrew Dunstan <andrew@dunslane.net>)
Re: RETURN QUERY in PL/PgSQL?  (Neil Conway <neilc@samurai.com>)
List pgsql-hackers
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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: [PATCHES] Full page writes improvement, code update
Next
From: Tom Lane
Date:
Subject: Re: Better error message for select_common_type()