Re: ScalarArrayOpExpr and multi-dimensional arrays

On 2017/12/08 23:34, Tom Lane wrote: > Amit Langote 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[] = in

Re: ScalarArrayOpExpr and multi-dimensional arrays

Amit Langote 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

ScalarArrayOpExpr and multi-dimensional arrays

Hi. 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 LINE 1: select array[1] = any (array[array[1], array[2]]);