> 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