On Fri, Aug 12, 2011 at 11:26 AM, George MacKerron <g.j.macker...@lse.ac.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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
