no. The right way to handle this should be 'WHERE id IN :arrayParam' Reuse one prepared statement for all id set sizes.
It really bothers me that `WHERE id IN ()` is not valid SQL. Checking for inclusion in an empty set should be valid.
-
-
-
The only backend for which that is an option is PG, which has special operators for it.
End of conversation
New conversation -
-
-
and Oracle. We have so many issues with slow IN queries with 100s if elems. Hibernate sadly doesn't know about arrays :(
-
Which is why Diesel prefers arrays when possible. I still have to handle backends which don't support it.
- 1 more reply
New conversation -
-
-
I know this is not what you are looking for, `WHERE id IN (select 0 limit 0)` will query for an empty set.
-
Doesn't work as a generic solution, invalid when used with a string column for example
- 1 more reply
New conversation -
-
-
it should be valid the same way where 1=0
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.