Tobias Petry: Unique Indexes With Some Rows Excluded

Unique indexes are used to ensure that some values or combinations of values are unique. However, they only work when the uniqueness constraint should be enforced on all table rows because it can...