​
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.