From: Bruce Momjian <bruce@momjian.us>
To: guyren@gmail.com
To: pgsql-docs@lists.postgresql.org
Subject: Re: Please provide examples of rows from
Date: Thu, 3 Sep 2020 21:46:18 -0400
Message-ID: <20200904014618.GB13932@momjian.us> (raw)
In-Reply-To: <158638264419.662.2482095087061084020@wrigleys.postgresql.org>
References: <158638264419.662.2482095087061084020@wrigleys.postgresql.org>
On Wed, Apr 8, 2020 at 09:50:44PM +0000, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/12/queries-table-expressions.html
> Description:
>
> The explanation of ROWS FROM is fairly terse and no examples are given.
>
> As it is essentially impossible to usefully search for this phrase, it would
> be helpful if at least a few examples were given.
Looking at this suggestion, this was all I could think of:
SELECT * FROM ROWS FROM (GENERATE_SERIES(1,10), GENERATE_SERIES(1, 15));
generate_series | generate_series
-----------------+-----------------
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5
6 | 6
7 | 7
8 | 8
9 | 9
10 | 10
(null) | 11
(null) | 12
(null) | 13
(null) | 14
(null) | 15
The issue with adding an example is that it is hard to do something
simple and have it illustrate anything. Does this help?
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EnterpriseDB https://enterprisedb.com
The usefulness of a cup is in its emptiness, Bruce Lee
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: bruce@momjian.us, guyren@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: Please provide examples of rows from
In-Reply-To: <20200904014618.GB13932@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox