8 ms·
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 uniqu
by mau013 2y ago
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 https://www.postgresql.org/docs/current/indexes-unique.html