From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
---|---|
To: | Wells Oliver <wells(dot)oliver(at)gmail(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: json_build_object, numeric types, and function limits on 100 arguments |
Date: | 2021-01-26 13:52:38 |
Message-ID: | 20210126135238.GA20826@alvherre.pgsql |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Karsten Lenz (KLE) | 2021-01-26 14:05:09 | RE: productive usage of PostgreSQL with Windows Server |
Previous Message | Thomas Kellerer | 2021-01-26 13:30:28 | Re: productive usage of PostgreSQL with Windows Server |