Doc: improve documentation for UNNEST().

Tom Lane <tgl@sss.pgh.pa.us>

Commit: bfda0a02444e204024d83db2874ec884960d24f0
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2021-01-27T17:50:17Z
Releases: 13.2
Doc: improve documentation for UNNEST().

Per a user question, spell out that UNNEST() returns array elements
in storage order; also provide an example to clarify the behavior for
multi-dimensional arrays.

While here, also clarify the SELECT reference page's description of
WITH ORDINALITY.  These details were already given in 7.2.1.4, but
a reference page should not omit details.

Back-patch to v13; there's not room in the table in older versions.

Discussion: https://postgr.es/m/FF1FB31F-0507-4F18-9559-2DE6E07E3B43@gmail.com

Files

PathChange+/−
doc/src/sgml/func.sgml modified +15 −4
doc/src/sgml/ref/select.sgml modified +12 −5

Documentation touched

Discussion