Finds all rows whose value on the stated column
is found on the specified values
.
supabase.postgrest["cities"].select(columns = Columns.list("name")) {
City::name isIn listOf("The Shire", "Mordor")
//or
isIn("name", listOf("The Shire", "Mordor"))
}
val toUpdate = City(name = "Mordor")
supabase.postgrest["cities"].update(toUpdate) {
City::name isIn listOf("Hobbiton", "Edoras")
//or
isIn("name", listOf("Hobbiton", "Edoras"))
}
supabase.postgrest["cities"].delete {
City::name isIn listOf("Hobbiton", "Edoras")
//or
isIn("name", listOf("Hobbiton", "Edoras"))
}
supabase.postgrest.rpc("echo_all_cities") {
City::name isIn listOf("Hobbiton", "Edoras")
//or
isIn("name", listOf("Hobbiton", "Edoras"))
}