From: | John Lumby <johnlumby(at)hotmail(dot)com> |
---|---|
To: | "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org> |
Subject: | Set-Returning functions in a select list |
Date: | 2021-07-27 16:19:42 |
Message-ID: | DM5PR06MB3082924AB2D1A3135D23F9C1A3E99@DM5PR06MB3082.namprd06.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2021-07-27 17:24:03 | Re: Set-Returning functions in a select list |
Previous Message | Bruce Momjian | 2021-07-27 02:55:25 | Re: Manua correction |