The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/static/functions-subquery.html Description:
Hi. The [DOC](https://www.postgresql.org/docs/10/static/functions-subquery.html) says: The result is NULL if the comparison does not return false for any subquery row does *any* mean here: some or all? For example in [MySQL](https://dev.mysql.com/doc/refman/8.0/en/any-in-some-subqueries.html) I have found this explanation: >Use of the word SOME is rare, but this example shows why it might be useful. To most people, the English phrase “a is not equal to any b” means “there is no b which is equal to a,” but that is not what is meant by the SQL syntax. The syntax means “there is some b to which a is not equal.” Using <> SOME instead helps ensure that everyone understands the true meaning of the query.