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

2016-12-09 Thread Raymond O'Donnell
On 09/12/16 10:42, Raymond O'Donnell wrote: 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

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

2016-12-09 Thread Raymond O'Donnell
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

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

2016-12-08 Thread VENKTESH GUTTEDAR
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