A check for exact equality (null, true, false), finds all rows whose value on the stated column
exactly match the specified value
.
is_
and in_
filter methods are suffixed with _
to avoid collisions with reserved keywords.
supabase.postgrest["cities"].select(columns = Columns.list("name")) {
City::name isExact null
//or
exact("name", null)
}
val toUpdate = City(name = "Mordor")
supabase.postgrest["cities"].update(toUpdate) {
City::name isExact null
//or
exact("name", null)
}
supabase.postgrest["cities"].delete {
City::name isExact null
//or
exact("name", null)
}
supabase.postgrest.rpc("echo_all_cities") {
City::name isExact null
//or
exact("name", null)
}