Thread: How to use Array in Array of Json
Dear Friends,My function definition is as:CREATE OR REPLACE FUNCTION schema1.samplefun1(vin_comp_cd smallint,vin_div_cd smallint,vin_loc_cd smallint[],vin_bt_cd integer[],)Here instead of passing parameter I want to just send a single i/p in Json[].My problem is how to pass array in Json[] variable. And how to use in code.
json_populate_record
Hi Monalee,
You can just use a json/jsonb variable. Content should be looking like this:
[
{“vin_comp_cd”: 1, “vin_div_cd”:11, “vin_array”: [{“vin_loc_cd”: 33, “vin_bt_cd”: 44}] },
…
{“vin_comp_cd”: N, “vin_div_cd”:NN, “vin_array”: [{“vin_loc_cd”: AA, “vin_bt_cd”: BB}] }
]
Or if “vin_loc_cd” and “vin_bt_cd” can be independent arrays if they are independent.
Best,
Igor
From: Monalee Bhandge <monalee.bhandge@epps-erp.com>
Sent: Monday, November 25, 2019 4:02 AM
To: pgsql-sql@lists.postgresql.org
Subject: How to use Array in Array of Json
Dear Friends,
My function definition is as:
CREATE OR REPLACE FUNCTION schema1.samplefun1(
vin_comp_cd smallint,
vin_div_cd smallint,
vin_loc_cd smallint[],
vin_bt_cd integer[],
)
Here instead of passing parameter I want to just send a single i/p in Json[].
My problem is how to pass array in Json[] variable. And how to use in code.
Thanking You!
Monalee
Database Lead Engineer.
Hi Monalee,
You can just use a json/jsonb variable. Content should be looking like this:
[
{“vin_comp_cd”: 1, “vin_div_cd”:11, “vin_array”: [{“vin_loc_cd”: 33, “vin_bt_cd”: 44}] },
…
{“vin_comp_cd”: N, “vin_div_cd”:NN, “vin_array”: [{“vin_loc_cd”: AA, “vin_bt_cd”: BB}] }
]
Or if “vin_loc_cd” and “vin_bt_cd” can be independent arrays if they are independent.
Best,
Igor
From: Monalee Bhandge <monalee.bhandge@epps-erp.com>
Sent: Monday, November 25, 2019 4:02 AM
To: pgsql-sql@lists.postgresql.org
Subject: How to use Array in Array of Json
Dear Friends,
My function definition is as:
CREATE OR REPLACE FUNCTION schema1.samplefun1(
vin_comp_cd smallint,
vin_div_cd smallint,
vin_loc_cd smallint[],
vin_bt_cd integer[],
)
Here instead of passing parameter I want to just send a single i/p in Json[].
My problem is how to pass array in Json[] variable. And how to use in code.
Thanking You!
Monalee
Database Lead Engineer.