doc(faq): mention how to invert `= ANY($1)`
@@ -29,6 +29,14 @@ Even when SQLx gains generic placeholder expansion for arrays, this will still b
as comma-expansion means each possible length of the array generates a different query
(and represents a combinatorial explosion if more than one array is used).
+Note that you can use any operator that returns a boolean, but beware that `!= ANY($1)` is **not equivalent** to `NOT IN (...)` as it effectively works like this:
+
+`lhs != ANY(rhs) -> lhs != rhs[0] OR lhs != rhs[1] OR ... lhs != rhs[length(rhs) - 1]`
+
+The equivalent of `NOT IN (...)` would be `!= ALL($1)`:
+
+`lhs != ALL(rhs) -> lhs != rhs[0] AND lhs != rhs[1] AND ... lhs != rhs[length(rhs) - 1]`
+
See also: [Postgres Manual, Section 9.24: Row and Array Comparisons](https://www.postgresql.org/docs/current/functions-comparisons.html)
-----
