Finds all rows where the value of the column matches any of the specified patterns
An empty patterns list matches no rows, because PostgreSQL evaluates ANY over an empty array as false.
ANY