Postgres Pro
Downloads
Home   >   mailing lists

How to use Array in Array of Json - Mailing list pgsql-sql

From Monalee Bhandge
Subject How to use Array in Array of Json
Date
Msg-id CAErOoCcu=xuySa1Za0acZ5hO4OjYs5982+9=6keV0dbZQTfK+w@mail.gmail.com
Whole thread Raw
Responses Re: How to use Array in Array of Json  (Steve Midgley <science@misuse.org>)
RE: How to use Array in Array of Json  (<2.andriychuk@gmail.com>)
List pgsql-sql
Tree view
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.

pgsql-sql by date:

Previous
From: legrand legrand
Date:
Subject: Re: install problem with extensions
Next
From: Steve Midgley
Date:
Subject: Re: How to use Array in Array of Json