Basic Usage

regex_phrase matches a specific sequence of regex queries. It is similar to phrase but allows for more flexibility in the query.
SELECT description, rating, category
FROM mock_items
WHERE id @@@ paradedb.regex_phrase('description', ARRAY['.*nning', '.*oes']);
field
required
Specifies the field within the document to search for the term.
regexes
required
An ARRAY of regex queries that the search is looking to match.
slop
default:0
A slop of 0 requires the terms to appear exactly as they are in the phrase and adjacent to each other. Higher slop values allow for more distance between the terms.
max_expansions
Limits the number of term variations that the prefix can expand to during the search. This helps in controlling the breadth of the search by setting a cap on how many different terms the prefix can match.
Setting slop equal to n allows n terms to come in between the terms in the phrase.
SELECT description, rating, category
FROM mock_items
WHERE id @@@ paradedb.regex_phrase('description', ARRAY['.*eek', 'shoes'], slop => 1, max_expansion => 10);