Postgres is adding a "unique nulls not unique" index, which prevents duplicate nulls. Normally a unique index allows duplicates if any column is null, so duplicate values of (123, null) are allowed.

Sign in to participate in the conversation

The social network of the future: No ads, no corporate surveillance, ethical design, and decentralization! Own your data with Mastodon!