Skip to main content

.rangeAdjacent()

const { data, error } = await supabase
  .from('countries')
  .select('name, id, population_range_millions')
  .rangeAdjacent('population_range_millions', '[70, 185]')

Examples​

With select()​

const { data, error } = await supabase
  .from('countries')
  .select('name, id, population_range_millions')
  .rangeAdjacent('population_range_millions', '[70, 185]')

With update()​

const { data, error } = await supabase
  .from('countries')
  .update({ name: 'Mordor' })
  .rangeAdjacent('population_range_millions', '[70, 185]')

With delete()​

const { data, error } = await supabase
  .from('countries')
  .delete()
  .rangeAdjacent('population_range_millions', '[70, 185]')

With rpc()​

// Only valid if the Postgres function returns a table type.
const { data, error } = await supabase
  .rpc('echo_all_countries')
  .rangeAdjacent('population_range_millions', '[70, 185]')