Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iZH0O-0002Iz-Fg for pgsql-sql@arkaria.postgresql.org; Mon, 25 Nov 2019 16:14:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iZH0N-0007jT-88 for pgsql-sql@arkaria.postgresql.org; Mon, 25 Nov 2019 16:14:27 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from <2.andriychuk@gmail.com>) id 1iZH0M-0007jM-Tz for pgsql-sql@lists.postgresql.org; Mon, 25 Nov 2019 16:14:27 +0000 Received: from mail-pl1-x635.google.com ([2607:f8b0:4864:20::635]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from <2.andriychuk@gmail.com>) id 1iZH0J-0003Kp-EA for pgsql-sql@lists.postgresql.org; Mon, 25 Nov 2019 16:14:26 +0000 Received: by mail-pl1-x635.google.com with SMTP id t8so6632211plr.8 for ; Mon, 25 Nov 2019 08:14:22 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:references:in-reply-to:subject:date:message-id:mime-version :thread-index:content-language; bh=HsUcbhMgpsVrGmzGx6/2vUk0Ks3DSaXr0HoPW3D8C0c=; b=AbHrySndz067PI7NNFg6CKZ6B534CnJaMYTDGIW5aRs256KAPRrPUMSOaRbkwnUzDx dEUpza0XfhgoqUw+Jj2mR4INZAJttxkQtuKi1Sg+St3Z9sHirXSz9HOmGui2PvOT+mx2 MH/QIe/SJcibMWgBj3cYMwfo5rILX8sfSve0ZntWpmm8QBZ+XXYxujNFe34gjbX+J1Mk lc0LBU1H0c+sqQFlIsPQsPAUb7XqQm8p/PsfrDlN3aCvl+RPknkh32hTR7+z2tdEDwLo BybAd1GleDsJ6ObrZX+118I2HHESAePmR+fVQY/osCffViZV00+EuDQfdVavR1osuBTd x0lQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:references:in-reply-to:subject:date :message-id:mime-version:thread-index:content-language; bh=HsUcbhMgpsVrGmzGx6/2vUk0Ks3DSaXr0HoPW3D8C0c=; b=Wpf/y9ciWoMmt430PFFpIpYNF+ynvHQg6db66q27WElsHgN7OOqF/CHzy6Ny2JGcTO VtVabJvQu/77LkFL6pnJs9Qsu8G/JMDqt2tzGe7lZcweSN5xn4Tp3nO95c925b9HHl7v 78ffEQRnStRZbwWy6g9URt2IZbvVkl1oZgv97fyVkFEZ2xKq+K992tdBupQr1vFdEar+ k5JPahxsjSpUMX7wmW1Qb8Svzzoyp1l2QbCegp/w4qnKYNNlAavg1bCvdiwCIOI2xLiT QH7df1WXfLvI2yw0WHv95dIvgu5UX6Rgh9ar/oAbCCLeTPmKh8q5MTzkFtgk7/US5AHc JTBA== X-Gm-Message-State: APjAAAW+qWnTW4/p0VIB8EJYCm981u7BtQPIKS+yGzzevwLRyuYMcxh9 TE0v4Y18xeskI+nniDPnbEy7BTFn X-Google-Smtp-Source: APXvYqxYpUSNPRBkXauE7EzlUKcrkgqYtOWjtnVJvlAuNn9zHwBscJfkoify6hLOWWroD5WypziSNg== X-Received: by 2002:a17:902:ac97:: with SMTP id h23mr23085662plr.237.1574698459546; Mon, 25 Nov 2019 08:14:19 -0800 (PST) Received: from IgorLaptop (198-27-163-253.fiber.dynamic.sonic.net. [198.27.163.253]) by smtp.gmail.com with ESMTPSA id v24sm9052738pfn.53.2019.11.25.08.14.18 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 25 Nov 2019 08:14:19 -0800 (PST) From: <2.andriychuk@gmail.com> To: "'Monalee Bhandge'" , References: In-Reply-To: Subject: RE: How to use Array in Array of Json Date: Mon, 25 Nov 2019 08:14:18 -0800 Message-ID: <044e01d5a3ab$642ddcc0$2c899640$@gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_044F_01D5A368.560B6010" X-Mailer: Microsoft Outlook 16.0 Thread-Index: AQKHBDtOj8c8dWdF4MzkYVREsDUc0qY5TGyA Content-Language: en-us X-Antivirus: Avast (VPS 191125-0, 11/25/2019), Outbound message X-Antivirus-Status: Clean List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multipart message in MIME format. ------=_NextPart_000_044F_01D5A368.560B6010 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Hi Monalee, =20 You can just use a json/jsonb variable. Content should be looking like = this: =20 [ {=E2=80=9Cvin_comp_cd=E2=80=9D: 1, =E2=80=9Cvin_div_cd=E2=80=9D:11, = =E2=80=9Cvin_array=E2=80=9D: [{=E2=80=9Cvin_loc_cd=E2=80=9D: 33, = =E2=80=9Cvin_bt_cd=E2=80=9D: 44}] }, =E2=80=A6 {=E2=80=9Cvin_comp_cd=E2=80=9D: N, =E2=80=9Cvin_div_cd=E2=80=9D:NN, = =E2=80=9Cvin_array=E2=80=9D: [{=E2=80=9Cvin_loc_cd=E2=80=9D: AA, = =E2=80=9Cvin_bt_cd=E2=80=9D: BB}] } =20 ] =20 Or if =E2=80=9Cvin_loc_cd=E2=80=9D and =E2=80=9Cvin_bt_cd=E2=80=9D can = be independent arrays if they are independent. =20 Best, Igor =20 From: Monalee Bhandge =20 Sent: Monday, November 25, 2019 4:02 AM To: pgsql-sql@lists.postgresql.org Subject: How to use Array in Array of Json =20 Dear Friends, My function definition is as: =20 CREATE OR REPLACE FUNCTION schema1.samplefun1( vin_comp_cd smallint, vin_div_cd smallint, vin_loc_cd smallint[], vin_bt_cd integer[], ) =20 Here instead of passing parameter I want to just send a single i/p in = Json[]. =20 My problem is how to pass array in Json[] variable. And how to use in = code. =20 =20 Thanking You! Monalee Database Lead Engineer. ------=_NextPart_000_044F_01D5A368.560B6010 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable

Hi Monalee,

 

You can just = use a json/jsonb variable. Content should be looking like = this:

 

[

{=E2=80=9Cvin_comp_cd=E2=80=9D: 1, = =E2=80=9Cvin_div_cd=E2=80=9D:11, =E2=80=9Cvin_array=E2=80=9D: = [{=E2=80=9Cvin_loc_cd=E2=80=9D: 33, =E2=80=9Cvin_bt_cd=E2=80=9D: 44}] = },

=E2=80=A6

{=E2=80=9Cvin_comp_cd=E2=80=9D: N, = =E2=80=9Cvin_div_cd=E2=80=9D:NN, =E2=80=9Cvin_array=E2=80=9D: = [{=E2=80=9Cvin_loc_cd=E2=80=9D: AA, =E2=80=9Cvin_bt_cd=E2=80=9D: BB}] = }

 

]

 

Or if = =E2=80=9Cvin_loc_cd=E2=80=9D and =E2=80=9Cvin_bt_cd=E2=80=9D 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.

------=_NextPart_000_044F_01D5A368.560B6010--