Tutorial: UNIQUE constraint on NULL values in PostgreSQL 21 March 2017 Posted in: Database About: Distinguishing between NULL values is impossible, as per SQL standard. These are my favorite workarounds for one and multiple columns.