On 01/08/2015 02:12 AM, Roy Blum wrote:
> I have created a function *myresult()* that receives as input Table
> name, and a Prefix, it then creates an SQL one liner command to SELECT
> from the specified table only the columns that share the designated
> prefix. It output a string which is basically the desired SQL command.
> My function is as follows and I show how I call it as well:
This is reposted from Stack Overflow, where it has already been pretty
comprehensively answered.
http://stackoverflow.com/q/27808534/398670
http://stackoverflow.com/q/27824725/398670
As suggested earlier - return a refcursor.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services