Postgres Pro
Downloads
Home   >   mailing lists

Re: NULL values seem to short-circuit my unique index - Mailing list pgsql-general

From Tom Lane
Subject Re: NULL values seem to short-circuit my unique index
Date
Msg-id 25115.1222657490@sss.pgh.pa.us
Whole thread Raw
In response to NULL values seem to short-circuit my unique index  (Matthew Wilson <matt@tplus1.com>)
List pgsql-general
Tree view 
Matthew Wilson <matt@tplus1.com> writes:
> It seems like I can insert two rows with NULL values in a column with a
> unique constraint just fine.

This is per SQL spec and quite well-documented in our manual ...

            regards, tom lane

pgsql-general by date:

Previous
From: Chris
Date:
Subject: Re: NULL values seem to short-circuit my unique index
Next
From: Klint Gore
Date:
Subject: Re: NULL values seem to short-circuit my unique index