Re: json_build_object, numeric types, and function limits on 100 arguments - Mailing list pgsql-admin

On 2021-Jan-25, Wells Oliver wrote:

> Hi. I am trying to build a Large JSON Object, and running into issues with
> the function limit on 100 arguments. I know I can use ARRAY[] to get around
> this, but I can't mix text and numeric types, which I need to do to have a
> nicely usable JSON object.
> 
> I know I can do this: json_build_object('somekey', 1.0, 'someotherkey',
> 2.0) but cannot put more than 100.

Maybe you can use the jsonb || jsonb operator:

select json_build_object('somekey', 1.0, 'someotherkey', 2.0)::jsonb || json_build_object('thirdkey', 3.0)::jsonb;
                        ?column?                        
────────────────────────────────────────────────────────
 {"somekey": 1.0, "thirdkey": 3.0, "someotherkey": 2.0}
(1 fila)


-- 
Álvaro Herrera                            39°49'30"S 73°17'W