Re: Create a function that creates a function which returns a table and return that table in one step

Rainer Schuetz <rs(at)bagong(dot)de> writes:
> I have a function (the 'outer' function) that creates another function
> which runs a select-query on a table. This table is specified by a
> parameter I use when running the outer function (there are many
> tables, on which the query could be executed and I would like to
> prevent having to write my function for each of them).

Introducing the extra function seems to be just complicating your life.
Why don't you just EXECUTE the desired SELECT directly from the main
function?

regards, tom lane