Set-Returning functions in a select list
От | John Lumby |
---|---|
Тема | Set-Returning functions in a select list |
Дата | |
Msg-id | DM5PR06MB3082924AB2D1A3135D23F9C1A3E99@DM5PR06MB3082.namprd06.prod.outlook.com обсуждение исходный текст |
Ответы |
Re: Set-Returning functions in a select list
|
Список | 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 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
В списке pgsql-docs по дате отправления: