I have been using Postgres for 10 years and didn't knew you could have a IN with... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		h1fra on Aug 31, 2023 \| parent \| context \| favorite \| on: When should you use the IN instead of the OR opera... I have been using Postgres for 10 years and didn't knew you could have a IN with multiple columns. I don't see a lot of use cases for it right now though (in a regular app)

chopin on Aug 31, 2023 [–]

I have a CSV import. For this it is necessary to select by key columns. Multiple columns within IN come in handy for that. Unfortunately I don't use Postgres.

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