Re: returning SETOF RECORD

On 07/14/2014 03:44 PM, Robert Haas wrote:
> populate_record_worker in jsonfuncs.c says this:
>
> if (get_call_result_type(fcinfo, NULL, &tupdesc) != TYPEFUNC_COMPOSITE)
> ereport(ERROR,
> (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
> errmsg("function returning record called in context "
> "that cannot accept type record"),
> errhint("Try calling the function in the FROM clause "
> "using a column definition list.")));
>
> dblink.c has a similar incantation.
>
> Is there any reasonable alternative? That is, if you have a function
> returning SETOF record, and the details of the record type aren't
> specified, is there anything you can do other than error out like
> this?
>

Not that I can see. What would you suggest?

cheers

andrew