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 particular a 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 little about the effect of placing one or more what set-returning functions in the SELECT-list. Also there should be a reference to the chapters under "Query Language (SQL) Functions" , especially sub-chapter "SQL Functions Returning Sets" Cheers, John