> Semantics between ANY and IN are very slightly different, but 95% of the case ... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

masklinn on Feb 11, 2022 | parent | context | favorite | on: A Hairy PostgreSQL Incident

> Semantics between ANY and IN are very slightly different, but 95% of the case it'll get the job done and provide better stats

And it’ll be more reliable, because `any` will be happy to take an empty array while `IN` will be very cross if given an empty tuple.

Shorn on Feb 11, 2022 [–]

> `any` will be happy

> `in` will be very cross

I like this. People should anthropomorphize their operators more.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact