Postgres Pro
Downloads
Home   >   mailing lists

Re: Document aggregate functions better w.r.t. ORDER BY - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Document aggregate functions better w.r.t. ORDER BY
Date
Msg-id CAKFQuwb3_r5E_6aVb6Nr4_P-HX29GYfwRJjWCjPibp7xfJLtFA@mail.gmail.com
Whole thread Raw
In response to Re: Document aggregate functions better w.r.t. ORDER BY  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Document aggregate functions better w.r.t. ORDER BY
List pgsql-hackers
Tree view
On Thu, Oct 26, 2023 at 3:36 PM Bruce Momjian <bruce@momjian.us> wrote:
No sneaking.  ;-)  It would be bad to document this unevenly because it
sets expectations in other parts of the system if we don't mention it.

Agreed.

Last suggestion, remove the first jsonb_agg example that lacks an order by.

+WITH vals (k, v) AS ( VALUES ('key0','1'), ('key1','3'), ('key1','2') )
+SELECT jsonb_object_agg(k, v) FROM vals;
+      jsonb_object_agg
+----------------------------
+ {"key0": "1", "key1": "2"}
+

We shouldn't write an example that relies on the rows being evaluated 1-2-3 without specifying an order by clause.

David J.

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Document aggregate functions better w.r.t. ORDER BY
Next
From: Jeff Davis
Date:
Subject: Re: Does UCS_BASIC have the right CTYPE?