Re: Please provide examples of rows from - Mailing list pgsql-docs

From Tom Lane
Subject Re: Please provide examples of rows from
Date
Msg-id 1668963.1600974324@sss.pgh.pa.us
Whole thread Raw
In response to Re: Please provide examples of rows from  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Please provide examples of rows from  (Bruce Momjian <bruce@momjian.us>)
List pgsql-docs
Bruce Momjian <bruce@momjian.us> writes:
> Yes, this is very helpful.  I was afraid the JSON would overwhelm the
> example, but this looks good.  I wrote the attached doc patch which I
> think improves this.  I plan to apply it to all supported versions.

Couple thoughts:

* Taking the initial ... out of the syntax synopsis is not an improvement.
It makes it look like you can only apply AS to the first function of a
ROWS FROM.

* I think the ORDER BY adds nothing to the example except complication
and confusion.

* Maybe the other sentence of explanation would read better as

    json_to_recordset() is instructed to return two columns,
    the first integer and the second text.  The result of
    generate_series() is used directly.

            regards, tom lane



pgsql-docs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Please provide examples of rows from
Next
From: Bruce Momjian
Date:
Subject: Re: Please provide examples of rows from