Matthew Wilson wrote:
> I'm trying to comprehend how NULL values interact with unique indexes.
> It seems like I can insert two rows with NULL values in a column with a
> unique constraint just fine.
> Is there something special about NULL? Can anyone post some links to
> explain what is going on?
When you think of null as "unknown", it makes sense.
Does an unknown value equal another unknown value?
Postgresql & php tutorials
In response to
pgsql-general by date
|Next:||From: Tom Lane||Date: 2008-09-29 03:04:50|
|Subject: Re: NULL values seem to short-circuit my unique index |
|Previous:||From: Matthew Wilson||Date: 2008-09-29 02:32:56|
|Subject: NULL values seem to short-circuit my unique index|