↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Feature: UNIQUE NULLS NOT DISTINCT

By default, NULL values are treated as distinct entries. Specifying NULLS NOT DISTINCT on unique indexes / constraints will cause NULL to be treated as not distinct, or in other words, equivalently.