Database
Mutually exclusive to a range
Match rows whose range column is immediately adjacent to the supplied range.
Filter rows where column -|- [start, finish) — the column's range shares an endpoint with the supplied range but doesn't overlap. PostgREST operator: adj.
Signature
builder.range_adjacent(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 adjacent to a window
supabase
.from("bookings")
.select("*")
.range_adjacent("during", ["2026-06-01", "2026-07-01"])
.execute