Set-Returning functions in a select list

2021-07-27 Thread John Lumby
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 an

Re: description of Aggregate Expressions

2019-12-06 Thread John Lumby
John Lumby wrote: < < Tom Lane wrote < < > > How about replacing "expression [ , ... ]" by "parameter_list" in the description, < > > and then stating that parameter_list can be either a single expression or , < > > if the partic

Re: description of Aggregate Expressions

2019-12-06 Thread John Lumby
Tom Lane wrote > > How about replacing "expression [ , ... ]"  by "parameter_list" in the > > description, > > and then stating that parameter_list can be either a single expression or , > >  if the particular aggregate function accepts it (for which,   consult that > > function's reference),

Re: description of Aggregate Expressions

2019-12-06 Thread John Lumby
On 12/05/19 18:06, David G. Johnston wrote: On Thu, Dec 5, 2019 at 3:18 PM John Lumby <<mailto:johnlu...@hotmail.com>johnlu...@hotmail.com<mailto:johnlu...@hotmail.com>> wrote: In PostgreSQL 12.1 Documentation chapter 4.2.7. Aggregate Expressions it says The syntax of an ag

description of Aggregate Expressions

2019-12-05 Thread John Lumby
y one expression. Cheers, John Lumby