On Wed, 19 Jan 2005, Dann Corbit wrote: > 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. The unique index is however used to model the unique constraint in PostgreSQL which I had thought was clear from my statement so giving the unique index behavior which makes it unable to model the constraint wouldn't be terribly workable (without rewriting the constraint to be modeled in a separate fashion). > -----Original Message----- > From: Stephan Szabo [mailto:sszabo@xxxxxxxxxxxxxxxxxxxxx] > Sent: Wednesday, January 19, 2005 4:27 PM > To: Dann Corbit > Cc: vhikida@xxxxxxxxxxx; J. Greenlees; pgsql-general@xxxxxxxxxxxxxx > Subject: Re: 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. > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
