returning SETOF RECORD

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: returning SETOF RECORD
Date: 2014-07-14 19:44:45
Message-ID: CA+TgmoazghfbqPXdM1X5TiG3ZS74aAJnfAMPmy2m768Li5DqJw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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?

Thanks,

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2014-07-14 19:56:30 Re: Minmax indexes
Previous Message Andres Freund 2014-07-14 19:40:33 Re: Pg_upgrade and toast tables bug discovered