Sunday, September 28, 2008

Re: [GENERAL] NULL values seem to short-circuit my unique index

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

Sent via pgsql-general mailing list (
To make changes to your subscription:

No comments: