Re: ScalarArrayOpExpr and multi-dimensional arrays

Amit Langote <Langote_Amit_f8@lab.ntt.co.jp> writes:
> I wonder if ScalarArrayOpExpr is not really meant for multi-dimensional
> arrays appearing on the right hand side?  Because:
> # select array[1] = any (array[array[1], array[2]]);

> ERROR:  operator does not exist: integer[] = integer

You are falling into the misimpression that a 2-D array is an array of
1-D arrays.  It is not, even if the syntax makes it look like that.

ScalarArrayOpExpr just iterates over the array elements without regard
to dimensionality; so the LHS must be of the element type.

            regards, tom lane