range_term
filters over int4range
, int8range
, numrange
, tsrange
, and tstzrange
range fields.
The following query finds all ranges that contain a specific value:
range_term
can be used with boolean
queries to “push down” the range filter into the full text search query.
range_term
can also compare a Postgres range against the
range field.
RangeIntersects
as an option, here’s how we would write it: