PostgreSQL IN matches any value in list - how do I match all values in list?

Question

In PostgreSQL IN can be used to match any value in a list. What if I need to match all values in a list? Is there a way to do this in PostgreSQL?

Answer 1

try = ALL (subquery) instead of IN (see manual)