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


Reply via email to