Python: Column contains every element in a value

Only relevant for jsonb, array, and range columns. Match only rows where column contains every element appearing in value.

Parameters

• column

  (Required)

  The column to filter on

• values

  (Required)

  The jsonb, array, or range value to filter with

Examples

On array columns

response = (
    supabase.table("issues")
    .select("*")
    .contains("tags", ["is:open", "priority:low"])
    .execute()
)

On range columns

response = (
    supabase.table("reservations")
    .select("*")
    .contains("during", "[2000-01-01 13:00, 2000-01-01 13:30)")
    .execute()
)

On `jsonb` columns

response = (
    supabase.table("users")
    .select("*")
    .contains("address", {"postcode": 90210})
    .execute()
)