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.

The parse query accepts a Tantivy query string. The intended use case is for accepting raw query strings provided by the end user. To use it, pass the key field to the left-hand side of @@@ and pdb.parse('<query>') to the right-hand side. 
SELECT description, rating, category FROM mock_items
WHERE id @@@ pdb.parse('description:(sleek shoes) AND rating:>3');
Please refer to the Tantivy docs for an overview of the query string language.

​
Lenient Parsing

By default, strict syntax parsing is used. This means that if any part of the query does not conform to Tantivy’s query string syntax, the query fails. For instance, a valid field name must be provided before every query (i.e. category:footwear). By setting lenient to true, the query is executed on a best-effort basis. For example, if no field names are provided, the query is executed over all fields in the index. 
SELECT description, rating, category FROM mock_items
WHERE id @@@ pdb.parse('description:(sleek shoes) AND rating:>3', lenient => true);

​
Conjunction Mode

By default, terms in the query string are ORed together. With conjunction_mode set to true, they are instead ANDed together. For instance, the following query returns documents containing both sleek and shoes. 
SELECT description, rating, category FROM mock_items
WHERE id @@@ pdb.parse('description:(sleek shoes)', conjunction_mode => true);