Re: Unique Index

True, but the standard says nothing about the creation of an index, so
you can make it behave in any way that you see fit.

-----Original Message-----
From: Stephan Szabo [mailto:sszabo(at)megazone(dot)bigpanda(dot)com]
Sent: Wednesday, January 19, 2005 4:27 PM
To: Dann Corbit
Cc: vhikida(at)inreach(dot)com; J. Greenlees; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Unique Index

On Wed, 19 Jan 2005, Dann Corbit wrote:

> Even at that, I think that being able to insert more than one null
value
> into a unique index should be considered as a bug (or diagnosed as an
> error).

AFAICT the UNIQUE constraint that it's used to model explicitly allows
multiple NULLs in the spec so I don't see making it error as being
terribly workable.