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 по дате отправления: