Conditional unique indexes in Rails and PostgreSQL

This is a simple example of adding a conditional and partial unique index to Rails applications backed by PostgreSQL.To demonstrate adding a conditional unique index I will use a following User model that I want to add.