title: Can I conditionally enforce a uniqueness constraint?
body: <p>My database contains a table of users. Every active user has a unique username. I'd like to be able to deactivate a user and free up the username they're using, but keep them in the same table.</p>
  
  <p>Is there a way to only conditionally enforce the uniqueness constraint?</p>