Python: Contained by value

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

Parameters

• column

  (Required)

  The jsonb, array, or range column to filter on

• value

  (Required)

  The jsonb, array, or range value to filter with

Examples

On array columns

response = (
    supabase.table("classes")
    .select("name")
    .contained_by("days", ["monday", "tuesday", "wednesday", "friday"])
    .execute()
)

On range columns

response = (
    supabase.table("reservations")
    .select("*")
    .contained_by("during", "[2000-01-01 00:00, 2000-01-01 23:59)")
    .execute()
)

On `jsonb` columns

response = (
    supabase.table("users")
    .select("name")
    .contained_by("address", {})
    .execute()
)