If I create a unique, multi-column index will inserts fail on a NULL ==
NULL match?

That is:

> create unique index foo on bar( cola, colb, colc);
> insert into bar ( cola) values ('a');
> insert into bar ( cola) values ('a');

Should the second insert fail?

(The answer appears to be yes, but I'm hoping there is a way to set this up
so that the answer is no).

--Steve



Stephen Apiki
Developer
Appropriate Solutions, Inc. (www.AppropriateSolutions.com)
apiki@...