Hello,
I'm new to pl/pgsql and postgres and I need some help with a part of
my function. In the function I loop through a multidemensional array
( [n][3] ), once, while inside the loop, I find the index I want to
work with I would like to set a separate variable equal to the element
in the array at that index ( newVar = array[i] ).
I tried to accomplish this with the following bit of code:
newVar := mnArray[i]
but for some reason that assigned NULL to newVar, then I tried:
newVar := mnArray[i][3:3]
and that appeared to have worked, however when I try to index an
element in the newVar array it produces NULL. I'm wondering two
things, first, does mnArray[i][3:3] return an array or a string
representation of the element at that index (which in this case is an
array)? and secondly, how do I do what I want to do (make newVar an
array)?
Thanks,
Colin