Comment by silvestrov

> This fits with my mental model of how I think unique constraints should work with null values.

Agree, this should be the default for unique indexes. Why would you ever want multiple NULLs in an unique index?