Multidimentional array access

From: VENKTESH GUTTEDAR <venkteshguttedar(at)gmail(dot)com>
To: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Multidimentional array access
Date: 2016-12-09 15:05:46
Message-ID: CA+iwz4mO4-td-ceBxcVTyUrdv6cU69bnw_0g6QjzeuTpK1B9Ag@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I want to get the inner array in a multi dimentional array in a
pl/pgsql procedure.

Eg : {{1,2,3,4,5,6,7},{11,22,33,44,55,66,77}}

for i in array_lower(Eg, 1) .. array_upper(Eg, 1)
LOOP
array_value = Eg[i]
END LOOP;

But Eg[i] is assigning null to array_value

Help would be appreciated.

--
Regards :
Venktesh Guttedar.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2016-12-09 15:17:42 Re: Multidimentional array access
Previous Message Adrian Klaver 2016-12-09 14:49:06 Re: Unexplained statistics reset? Help tracking it down.