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
rod@iol.ie