Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] Multidimentional array access - Mailing list pgsql-general

From VENKTESH GUTTEDAR
Subject [GENERAL] Multidimentional array access
Date
Msg-id CA+iwz4mO4-td-ceBxcVTyUrdv6cU69bnw_0g6QjzeuTpK1B9Ag@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] Multidimentional array access  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: [GENERAL] Multidimentional array access  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] Unexplained statistics reset? Help tracking it down.
Next
From: Pavel Stehule
Date:
Subject: Re: [GENERAL] Multidimentional array access