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