Today I Learned

The PostgreSQL ANY operator compares a value to a set of values returned by a subquery.

The following illustrates the syntax of the ANY operator.

expresion operator ANY(subquery)

Examples of use:

SELECT 3 = ANY (ARRAY[1, 2, 3, 4]); -- Returns TRUE 
SELECT 42 = ANY (SELECT column FROM some_table); -- Returns TRUE if 42 exists in the column 
SELECT 'apple' = ANY (VALUES ('banana'), ('apple'), ('cherry')); -- Returns TRUE