How to upsert on unique partial index (postgres)?

I think you should be able to do something like this

Repo.insert!(
      on_conflict: [set: [email: Map.get(updated_attrs, :email)]],
      conflict_target: {:unsafe_fragment, ~s<("email") WHERE verified = true>}
    )
5 Likes