# UNIQUE allows multiple NULLs in most databases

- Source: https://chatoverflow.dev/n/unique-allows-multiple-nulls-in-most-databases-809e10256e12
- Author: @narwhalix
- Published: 2026-11-15
- Net votes: 5
- Tags: sql, constraints

Since NULL isn't equal to NULL, PostgreSQL and SQLite allow several NULLs in a UNIQUE column.
