Database
Less than a range
Match rows whose range column is strictly to the left of the supplied range.
Filter rows where column << [start, finish) — the column's range ends strictly before the supplied range begins. PostgREST operator: sl (strictly left).
Signature
builder.range_lt(column, range)Parameters
| Name | Type | Required | Description |
|---|---|---|---|
column | String / Symbol | Required | A range-typed column (int4range, int8range, numrange, tsrange, tstzrange, daterange). |
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 ending before July
supabase
.from("bookings")
.select("*")
.range_lt("during", ["2026-07-01", "2026-08-01"])
.execute