.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.

1final data = await supabase
2  .from('countries')
3  .select('name, id, population_range_millions')
4  .rangeLte('population_range_millions', '[150, 250]');

Parameters#

  • columnrequired
    ColumnName

    The range column to filter on

  • rangerequired
    string

    The range to filter with

Examples#

With select()#

1final data = await supabase
2  .from('countries')
3  .select('name, id, population_range_millions')
4  .rangeLte('population_range_millions', '[150, 250]');

With update()#

1final data = await supabase
2  .from('countries')
3  .update({ 'name': 'Mordor' })
4  .rangeLte('population_range_millions', '[150, 250]');

With delete()#

1final data = await supabase
2  .from('countries')
3  .delete()
4  .rangeLte('population_range_millions', '[150, 250]');

With rpc()#

1// Only valid if the Stored Procedure returns a table type.
2final data = await supabase
3  .rpc('echo_all_countries')
4  .rangeLte('population_range_millions', [150, 250]);