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(
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.