alt Hacker NewsYes, according to the manual, IN is equivalent to = ANY() https://www.postgresql.org/docs/current/functions-subquery.h...
I had to check because for some reason, I always thought =ANY was somehow better than IN.
Replies
tczMUFlmoNk • 05/04/2025
ANY can be used with arrays, particularly query parameters: `id = ANY($1::int[])`, but not `id IN $1::int[]`.
➕ show 1 reply
masklinn • 05/04/2025
It is, but in a pretty minor way: any can be used with no items, IN can not and will error.
IN is fine. The biggest problem comes with NOT IN, which has NULL semantics that makes life difficult for the planner. It is consistent but rarely what the user wants. NOT EXISTS is typically better there.