Basic Usage

Identifies documents containing a phrase followed by a term prefix. The field must be indexed with a record of position.
SELECT description, rating, category
FROM mock_items
WHERE id @@@ paradedb.phrase_prefix('description', ARRAY['running', 'sh']);
field
required
Specifies the field within the document to search for the term.
phrases
required
An ARRAY of words that the search is looking to match, followed by a term prefix rather than a complete term.
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.