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
