Skip to main content
Legacy Docs: This page describes our legacy API. It will be deprecated in a future version. Please use the v2 API where possible.
Compound queries combine multiple other queries. For instance, the following query looks for documents containing either the term running or shoes and boosts the relevance of documents matching shoes. 
SELECT description, rating, category
FROM mock_items
WHERE id @@@ paradedb.boolean(
    should => ARRAY[
        paradedb.boost(query => paradedb.term('description', 'shoes'), factor => 2.0),
        paradedb.term('description', 'running')
    ]
);
Compound query functions are composable, which allows for arbitrarily fine-grained queries.