If you were at all confused about what NULLS NOT DISTINCT means for a unique index in PostgreSQL, let this helpful explanation make it all perfectly clear:
> By default, NULL values are treated as distinct entries. Specifying NULLS NOT DISTINCT on unique indexes / constraints will cause NULL to […]
mastodon.social
Original post on mastodon.social