miller_2555 <nabble.30.miller_2...@spamgourmet.com> writes:
> I appreciate the clarification on the output. Given the assignment appears
> correct, what is the appropriate method to access the elements of the
> multidimensional array?
I think what you're missing is the distinction between slice and simple
element access, ie instead of this
(myvar[i]).multidimarray[j]
you'd need something like this
(myvar[i]).multidimarray[j][1:3]
The proposed loop coding is uselessly overcomplicated because it
supposes that 2-D arrays could be nonrectangular. Just use array_lower
and array_upper on dimension 2 of the 2-D array in the innermost loop.
You might want to practice a bit with a plain 2-D array field before
getting into the complexity of embedding it in a composite embedded
in an array ...
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
