Skip to main content
Version: v2 RC

overlaps()

Only relevant for array and range columns. Match only rows where column and value have an element in common.

const { data, error } = await supabase
.from('issues')
.select('title')
.overlaps('tags', ['is:closed', 'severity:high'])

Parameters

  • columnrequiredColumnName

    The array or range column to filter on

  • valuerequiredstring | array

    The array or range value to filter with

      Properties
    • objectrequiredobject

      No description provided.

    • stringrequiredobject

      No description provided.

Examples

On array columns

const { data, error } = await supabase
.from('issues')
.select('title')
.overlaps('tags', ['is:closed', 'severity:high'])

On range columns

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()
.overlaps('during', '[2000-01-01 12:45, 2000-01-01 13:15)')