Re: Functions returning setof record -- can I use a table type as my return type hint?

On Fri, Aug 12, 2011 at 11:26 AM, George MacKerron
<g(dot)j(dot)mackerron(at)lse(dot)ac(dot)uk> wrote:
> Many thanks for the reply, Ray.
>
> Unfortunately, I don't think this addresses the problem, because I'd hoped not to have to hard-code the table name into the function.
>
> The point of the function is that you can pass it any table name (along with some other parameters) and it returns rows from that named table.

you can't have it both ways. at the time the function call is
executed, the return type/fields must be known. you can do this by
either a. explicitly defining the function return type or b.
describing the function return type in the function call, or c. use a
generic type to hold the output record structure which can be
parsed/dealt with later, like text or hstore.

merlin