RE: How to use Array in Array of Json

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(dot)bhandge(at)epps-erp(dot)com>
Sent: Monday, November 25, 2019 4:02 AM
To: pgsql-sql(at)lists(dot)postgresql(dot)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.