PostgrestRangeFilters<Row, Bound extends Object> extension

Filters that only apply to range columns, typed PostgrestRange<Bound>.

Every operand is a PostgrestRange with the column's bound type, so during.rangeLt(PostgrestRange.closedOpen(2, 25)) on a tstzrange column does not compile.

on
Annotations
  • @experimental

Methods

containedBy(PostgrestRange<Bound> range) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, PostgrestRange<Bound>>, provided by the PostgrestRangeFilters extension

Only rows whose range lies within range.
contains(PostgrestRange<Bound> range) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, PostgrestRange<Bound>>, provided by the PostgrestRangeFilters extension

Only rows whose range contains every value of range.
containsElement(Bound value) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, PostgrestRange<Bound>>, provided by the PostgrestRangeFilters extension

Only rows whose range contains value.
overlaps(PostgrestRange<Bound> range) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, PostgrestRange<Bound>>, provided by the PostgrestRangeFilters extension

Only rows whose range shares at least one value with range.
rangeAdjacent(PostgrestRange<Bound> range) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, PostgrestRange<Bound>>, provided by the PostgrestRangeFilters extension

Only rows whose range is adjacent to range.
rangeGt(PostgrestRange<Bound> range) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, PostgrestRange<Bound>>, provided by the PostgrestRangeFilters extension

Only rows whose range is strictly to the right of range.
rangeGte(PostgrestRange<Bound> range) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, PostgrestRange<Bound>>, provided by the PostgrestRangeFilters extension

Only rows whose range does not extend to the left of range.
rangeLt(PostgrestRange<Bound> range) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, PostgrestRange<Bound>>, provided by the PostgrestRangeFilters extension

Only rows whose range is strictly to the left of range.
rangeLte(PostgrestRange<Bound> range) → PostgrestFilter<Row>

Available on PostgrestFilterableExpression<Row, PostgrestRange<Bound>>, provided by the PostgrestRangeFilters extension

Only rows whose range does not extend to the right of range.