Database
Less than or equal to a range
Match rows whose range column does not extend to the right of the supplied range.
Filter rows where column &< [start, finish) — the column's range does not end after the supplied range's upper bound. PostgREST operator: nxr (not extends right).
Signature
builder.range_lte(column, range)Parameters
| Name | Type | Required | Description |
|---|---|---|---|
column | String / Symbol | Required | A range-typed column. |
range | Array (length 2) | Required | Two-element array [lower, upper]. Wrapped as (lower,upper) on the wire. |
Returns
Returns
self (FilterRequestBuilder)
The same builder for chaining.
Example — bookings that finish on or before the window's end
supabase
.from("bookings")
.select("*")
.range_lte("during", ["2026-06-01", "2026-07-01"])
.execute