Re: [GENERAL] Multidimentional array access

2016-12-09 Thread Raymond O'Donnell
On 09/12/16 15:30, Tom Lane wrote: As of 9.6 you could use the shorthand array_value = Eg[i][:] regards, tom lane I hadn't spotted that - very handy - will go and read up on it. :-) Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via

Re: [GENERAL] Multidimentional array access

2016-12-09 Thread Tom Lane
VENKTESH GUTTEDAR writes: > 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]

Re: [GENERAL] Multidimentional array access

2016-12-09 Thread Pavel Stehule
Hi 2016-12-09 16:05 GMT+01:00 VENKTESH GUTTEDAR : > 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) >

[GENERAL] Multidimentional array access

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