Partial unique index as a workaround for the nonexistent partial unique constraint
Recently, I had to enforce the uniqueness of certain row values that meet certain conditions. The first solution which came to my mind was to use a unique constraint. Unfortunately, there is no something like partial unique constraint. Let's see how I solved it!