Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] How to loop through multi-dimentional array in PL/PGSQL - Mailing list pgsql-general

From VENKTESH GUTTEDAR
Subject [GENERAL] How to loop through multi-dimentional array in PL/PGSQL
Date
Msg-id CA+iwz4kw-LNgtiLKv0t85TiBZ1SZXrbh3ADiVxPHms+xfQwV=w@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] How to loop through multi-dimentional array in PL/PGSQL
List pgsql-general
Tree view
Hello,

    Please help me in accessing multi-dimentional array in postgresql PL/PGSQL.

    for i in array_lower(product_list, 1) .. array_upper(product_list, 1)
    LOOP
        product_list[i][0];
    END LOOP;

    Is the above code right?

    Or is there any other way to access, i am getting null for product_list[i][0];

    Any help would be appreciated.

--
Regards :
Venktesh Guttedar.

pgsql-general by date:

Previous
From: Roshan Jha
Date:
Subject: [GENERAL] Regrding:- Arduino-Postgresql Direct Connection
Next
From: Karsten Hilbert
Date:
Subject: Re: [GENERAL] Looking for an online mentor