Skip to main content
Version: v2 RC

rangeGt()

Only relevant for range columns. Match only rows where every element in column is greater than any element in range.

const { data, error } = await supabase
.from('reservations')
.select()
.rangeGt('during', '[2000-01-02 08:00, 2000-01-02 09: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()
.rangeGt('during', '[2000-01-02 08:00, 2000-01-02 09:00)')