Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.paradedb.com/llms.txt

Use this file to discover all available pages before exploring further.

Legacy Docs: This page describes our legacy API. It will be deprecated in a future version. Please use the v2 API where possible.

Basic Usage

Returns documents that match one or more of the specified subqueries. If a document matches multiple criteria, it receives the highest score from those matches.
SELECT description, rating, category, pdb.score(id)
FROM mock_items
WHERE id @@@ paradedb.disjunction_max(ARRAY[
  paradedb.term('description', 'shoes'),
  paradedb.term('description', 'running')
]);
disjuncts
required
Query objects to match against.
tie_breaker
default:0
A tie breaking increment for matching subqueries. Should be a float between 0 and 1.
If tie_breaker is provided, documents that match on more than one subquery will score higher than documents that match on only one subquery. For instance, if there are two subqueries and tie_breaker is set to 0.5, the score is computed as:
max_score + (second_highest_score × 0.5)