re the recent discussion ending with this thread
https://www.postgresql.org/message-id/1163940.1627142622%40sss.pgh.pa.us
in pgsql-general
I feel that more on this topic needs to be added to the reference information for SELECT,
both in the description of the (expressions in the) SELECT-list and in the description of the FROM list, and in
particulara note on how and why certain usages are equivalent when written in specific ways, (and maybe even which is
preferred).
Currently there is a thorough description of the semantics of [ LATERAL ] ROWS FROM in the FROM list, but very
littleabout the effect of placing one or more what set-returning functions in the SELECT-list. Also there should
bea reference to the chapters under "Query Language (SQL) Functions" , especially sub-chapter "SQL Functions
ReturningSets"
Cheers, John
