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

From Merlin Moncure
Subject Re: Functions returning setof record -- can I use a table type as my return type hint?
Date
Msg-id CAHyXU0z8B9OQsV4M+Si4Cjnd9s4TTGwwjQw+9Oas8_WrUXHozw@mail.gmail.com
Whole thread Raw
In response to Re: Functions returning setof record -- can I use a table type as my return type hint?  (George MacKerron <g.j.mackerron@lse.ac.uk>)
Responses Re: Functions returning setof record -- can I use a table type as my return type hint?
List pgsql-general
On Fri, Aug 12, 2011 at 11:26 AM, George MacKerron
<g.j.mackerron@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
intothe function. 
>
> The point of the function is that you can pass it any table name (along with some other parameters) and it returns
rowsfrom 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

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: COPY from .csv File and Remove Duplicates
Next
From: Raymond O'Donnell
Date:
Subject: Re: Functions returning setof record -- can I use a table type as my return type hint?