v.19.5New Features

Hyperscan Multiple Regular Expression Matching Was Added (functions Multimatchany, Multimatchanyindex, Multifuzzymatchany, Multifuzzymatchanyindex)

Hyperscan multiple regular expression matching was added (functions multiMatchAny, multiMatchAnyIndex, multiFuzzyMatchAny, multiFuzzyMatchAnyIndex). #4780, #4841 (Danila Kutenin)
Added support for multiple regular expression matching using Hyperscan with new functions: multiMatchAny, multiMatchAnyIndex, multiFuzzyMatchAny, and multiFuzzyMatchAnyIndex.

Why it matters

This feature leverages the Hyperscan library to enable efficient matching of multiple regular expressions simultaneously. It improves performance and convenience by allowing users to run multiple regex matches in a single function call, reducing overhead compared to individual regex evaluations.

How to use it

Use the new functions multiMatchAny, multiMatchAnyIndex, multiFuzzyMatchAny, or multiFuzzyMatchAnyIndex in your SQL queries to perform multiple regex matches concurrently. These functions accept arrays of patterns and return results according to their matching semantics.