Re: nextval parameter is not clear

2022-12-08 Thread Laurenz Albe
On Wed, 2022-12-07 at 14:32 -0700, David G. Johnston wrote: > While I agree with the conclusion that the function signature is an example, > and having more than one for these is probably overkill, we can address the > OP's complaint quite easily by doing what we do in many other places, give > eac

Clarify note about DISTINCT and ORDER BY in aggregates

2022-12-08 Thread Vik Fearing
The current docs can be read as using DISTINCT in an aggregate (count(distinct col)) and ORDER BY (array_agg(col ORDER BY col)) are both extensions to the standard. The actual truth is that our extension to the standard is to allow both at the same time. Attached is a trivial patch to make t