logoalt Hacker News

codesnik05/04/20251 replyview on HN

aren't they the same in Postgres?


Replies

frollogaston05/04/2025

Yes, 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.

show 3 replies