|Subject:||wish: optimize IN() to be ANY() for compatible PostgreSQL versions.|
When using "IN()" multiple times with variable lengths of the list, a prepared statement is made for each length of the list, creating extra overhead. On compatible PostgreSQL versions, we can avoid this overhead by using this, which means the same thing: ANY (ARRAY[1,2,3,4]) The difference is that you can paramterize like this: ANY (?) So that you can only get one prepared statement for each length of the IN clause. The "wish" is that for compatible PostgreSQL versions, we will rewrite "IN()" clauses to use "ANY". Or perhaps alternately, we could explicity support ANY(), and handle creating the "ARRAY" constructor for the users.