My bad -- thanks for the clarification.
— Max
> On Sep 18, 2020, at 4:09 AM, Magnus Hagander wrote:
>
>
>
>
>> On Fri, Sep 18, 2020 at 1:07 PM PG Doc comments form
>> wrote:
>> The following documentation comment has been logged on the website:
>>
>> Page: https://www.postgresql.org/doc
I wrote:
> You're right that the only suitable core function is going to be
> json[b]_to_recordset, but I don't see why you can't extend the
> existing example for that. Something like
Meh, I was too hasty and pushed "send" with a broken example. Better
=# select * from rows from
(json_to_reco
I wrote:
> Yeah, this error message needs some help. With a function having
> multiple OUT parameters, the prorettype is indeed "record", but
> the specific record type is implied by the OUT parameters so you
> do not need to (and can't) specify it in the query.
> The point of the AS feature is to
Bruce Momjian writes:
> but doing this to illustrate ROWS FROM is going to be complex.
You're right that the only suitable core function is going to be
json[b]_to_recordset, but I don't see why you can't extend the
existing example for that. Something like
# select * from rows from
(json_to_re