Re: the IN clause saga

Kris Jurka wrote:
> Perhaps these cases would also be illustrative as I believe that is what
> Fernando was suggesting.
>
> template1=# select 1 where 1 in (array[1,2,3]);
> ERROR: Unable to identify an operator '=' for types 'integer' and 'integer[]'
> You will have to retype this query using an explicit cast
> IN: op_error (parse_oper.c:608)
> ERROR: Unable to identify an operator '=' for types 'integer' and 'integer[]'
> You will have to retype this query using an explicit cast

Right, as I said, this syntax is trying to compare the scalar value to
the entire array value, not its elements.

> template1=# select 1 where 1 in ([1,2,3]);
> ERROR: syntax error at or near "["
> IN: yyerror (scan.l:596)
> ERROR: syntax error at or near "[" at character 22

And this syntax was never valid and still isn't.

Joe