Skip to main content
Version: v2 RC

rangeLte()

Only relevant for range columns. Match only rows where every element in column is either contained in range or less than any element in range.

const { data, error } = await supabase
.from('reservations')
.select()
.rangeLte('during', '[2000-01-01 14:00, 2000-01-01 16:00)')

Parameters

  • columnrequiredColumnName

    The range column to filter on

  • rangerequiredstring

    The range to filter with

Examples

With select()

Postgres supports a number of range types. You can filter on range columns using the string representation of range values.

const { data, error } = await supabase
.from('reservations')
.select()
.rangeLte('during', '[2000-01-01 14:00, 2000-01-01 16:00)')