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
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]
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)
>
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