How to use Array in Array of Json

From: Monalee Bhandge <monalee(dot)bhandge(at)epps-erp(dot)com>
To: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: How to use Array in Array of Json
Date: 2019-11-25 12:02:12
Message-ID: CAErOoCcu=xuySa1Za0acZ5hO4OjYs5982+9=6keV0dbZQTfK+w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Steve Midgley 2019-11-25 16:13:44 Re: How to use Array in Array of Json
Previous Message Pavel Stehule 2019-11-20 12:15:23 Re: PostGreSQL Replication and question on maintenance