Kotlin: Column is equal to a value

Finds all rows whose value on the stated column exactly matches the specified value.

Parameters

• column

  (Required)

  The column to filter on.

• value

  (Required)

  The value to filter with.

Examples

With select()

supabase.from("cities").select(columns = Columns.list("name", "country_id")) {
    filter {
        City::name eq "The Shire"
        //or
        eq("name", "The Shire")
    }
}

With update()

val toUpdate = City(name = "Mordor")
supabase.from("cities").update(toUpdate) {
    filter {
        City::name eq "Hobbiton"
        //or
        eq("name", "Hobbiton")
    }
}

With delete()

supabase.from("cities").delete {
    filter {
        City::name eq "Mordor"
        //or
        eq("name", "Mordor")
    }
}

With rpc()

supabase.postgrest.rpc("function") {
    filter {
        City::name eq "Mordor"
        //or
        eq("name", "Mordor")
    }
}