ANY

Define a comparison condition that returns true when the comparison is true for at least one value returned by a subquery. This kind of condition is synonymous with the IN condition.

ANY | SOME (subquery)

where subquery returns one column with 0 or more rows. ANY and SOME are synonyms.

For example:

premdb=# SELECT seasonid FROM season 
WHERE seasonid=ANY(SELECT seasonid FROM match);
 seasonid 
----------
        1
        2
        3
        4
        5
        6
        7
        8
        9
...

This query is equivalent to:

SELECT seasonid FROM season 
WHERE seasonid IN(SELECT seasonid FROM match);