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:[EMAIL PROTECTED] Sent: Wednesday, January 19, 2005 4:27 PM To: Dann Corbit Cc: [EMAIL PROTECTED]; J. Greenlees; pgsql-general@postgresql.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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
