Re: [GENERAL] How to loop through multi-dimentional array in PL/PGSQL

Fri, 09 Dec 2016 02:43:58 -0800 

On 09/12/16 06:35, VENKTESH GUTTEDAR wrote:

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];
By default, PostgreSQL uses 1-based arrays (i.e. no [0] slot), so maybe that's your problem. 

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to