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"))
    }
}