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@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 4: Don't 'kill -9' the postmaster
