On Thu, Oct 26, 2023 at 3:36 PM Bruce Momjian <bruce(at)momjian(dot)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.