Waiting for PostgreSQL 15 – Add UNIQUE null treatment option (depesz.com)

Which kinda makes sense in a single column context. Overall NULL semantics are what they are but in a single table column one can argue that two NULLs could be exactly the same thing.