Python: With a common element

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

Parameters

• column

  (Required)

  The array or range column to filter on

• value

  (Required)

  The array or range value to filter with

Examples

On array columns

response = (
    supabase.table("issues")
    .select("title")
    .overlaps("tags", ["is:closed", "severity:high"])
    .execute()
)

On range columns

response = (
    supabase.table("reservations")
    .select("*")
    .overlaps("during", "[2000-01-01 12:45, 2000-01-01 13:15)")
    .execute()
)