[mau013]

In Postgres you can chose whether to treat NULLs as distinct or not (meaning that when treating NULLs as NOT DISTINCT you can insert many for an otherwise unique row).

If I’m not mistaken this is the docs page: https://www.postgresql.org/docs/current/indexes-unique.html