On 6/17/06, David M. Cook <[EMAIL PROTECTED]> wrote:
says that nulls are distinct in a column, but I haven't found that to be the case (this is a test with 3.3.5) create table foo (bar text, baz text, unique(bar, baz));
select * from foo; bar|baz -------- quux|null quux|null quux|null
But if NULL is distinct for UNIQUE columns, isn't that the result you would expect?
