Query Builder
Range
Basic Usage
Finds documents containing a term that falls within a specified range of values.
SELECT * FROM search_idx.search(
query => paradedb.range(
field => 'rating',
range => '[1,3)'::int4range
),
stable_sort => true
);
field
required
Specifies the field within the document to search for the term.
range
required
A postgres range specifying the range of values to match the field against.
Range types include int4range
, int8range
, daterange
, tsrange
, and
tstzrange
.
Was this page helpful?