Date: Thu, 3 Sep 2020 21:46:18 -0400
From: Bruce Momjian <bruce@momjian.us>
To: guyren@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: Please provide examples of rows from
Message-ID: <20200904014618.GB13932@momjian.us>
References: <158638264419.662.2482095087061084020@wrigleys.postgresql.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <158638264419.662.2482095087061084020@wrigleys.postgresql.org>
User-Agent: Mutt/1.10.1 (2018-07-13)
Precedence: bulk

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