Re: returning SETOF RECORD - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: returning SETOF RECORD
Date
Msg-id 53C4400C.8040108@dunslane.net
Whole thread Raw
In response to returning SETOF RECORD  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: returning SETOF RECORD  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Minmax indexes
Next
From: Robert Haas
Date:
Subject: Re: returning SETOF RECORD