Yeah, thanks, I thought about that: concatenating a few different objects to make a bigger object. Seemed silly, but if there's not a cleaner solution, it does work.
On Tue, Jan 26, 2021 at 5:52 AM Alvaro Herrera <alvherre@xxxxxxxxxxxxxx> wrote:
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
Wells Oliver
wells.oliver@xxxxxxxxx
wells.oliver@xxxxxxxxx
