doc: show functions returning record types and use of ROWS FROM

Bruce Momjian <bruce@momjian.us>

Commit: 997188b6e0a11c60ddab369969ea2e57202941b8
Author: Bruce Momjian <bruce@momjian.us>
Date: 2020-10-05T20:27:33Z
Releases: 9.6.20
doc:  show functions returning record types and use of ROWS FROM

Previously it was unclear exactly how ROWS FROM behaved and how to cast
the data types of columns returned by FROM functions.  Also document
that only non-OUT record functions can have their columns cast to data
types.

Reported-by: guyren@gmail.com

Discussion: https://postgr.es/m/158638264419.662.2482095087061084020@wrigleys.postgresql.org

Backpatch-through: 9.5

Files

PathChange+/−
doc/src/sgml/queries.sgml modified +29 −1

Documentation touched