v.25.11Improvement
Support Array of String as
Support Array of String as an input to thehasAnyTokensorhasAllTokensfunctions. #89124 (Elmi Ahmadov).
Why it matters
This feature allows users to efficiently check if any or all tokens from an array of strings exist within a given string, simplifying queries that require token matching with multiple candidates and enhancing flexibility when working with tokenized string data.How to use it
Users can now provide an array of strings as an argument to thehasAnyTokens or hasAllTokens functions instead of a single string. For example:SELECT hasAnyTokens('sample text', ['token1', 'token2', 'sample'])This will check if any of the tokens in the array exist in the target string.