Re: Using "where col in (?)"

On Fri, 29 Apr 2022 at 11:32, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
wrote:

> On Fri, Apr 29, 2022 at 8:25 AM Blake McBride <blake1024(at)gmail(dot)com> wrote:
>
>> I am getting the following JDBC error:
>>
>
> The error is a PostgreSQL one, JDBC is just the messenger here.
>
>
>>
>> ERROR: operator does not exist: integer = integer[]
>> Hint: No operator matches the given name and argument types. You might
>> need to add explicit type casts. Position: 37
>>
>
>> select * from se_user where user_id in (?)
>>
>>
> Why are you expecting: "integer IN (integer[])" to work? It isn't
> documented anywhere that I'm aware of.
>
> You can write that as: "integer = ANY(integer[])" though, that is
> documented.
>

Thanks David, good catch!

Dave