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