Kotlin: 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 jsonb, array, or range column to filter on

• value

  (Required)

  The jsonb, array, or range value to filter with

Examples

With select()

supabase.from("cities").select(columns = Columns.list("name")) {
    filter {
       City::mainExports contains listOf("oil")
       //or
       contains("main_exports", listOf("oil"))
    }
}

With update()

val toUpdate = City(name = "Mordor")
supabase.from("cities").update(toUpdate) {
    filter {
       City::mainExports contains listOf("oil")
       //or
       contains("main_exports", listOf("oil"))
    }
}

With delete()

supabase.from("cities").delete {
    filter {
       City::mainExports contains listOf("oil")
       //or
       contains("main_exports", listOf("oil"))
    }
}

With rpc()

supabase.postgrest.rpc("echo_all_cities") {
    filter {
       City::mainExports contains listOf("oil")
       //or
       contains("main_exports", listOf("oil"))
    }
}