PostgreSQL: Composite UNIQUE Constraint does not consider NULL Values

PostgreSQL UNIQUE Constraint does not consider a NULL values for uniqueness. I am surprised when I found few duplicate values in my database where Unique key constraint already defined for that columns. I know the thumb rule of UNIQUE Constraint is, UNIQUE Key column can be a NULL. In my Postgres database, I applied Composite … Continue reading PostgreSQL: Composite UNIQUE Constraint does not consider NULL Values