Re: UNIQUE and NULL in SQL

From: Brian Smith <brian-l-smith_at_uiowa.edu>
Date: 31 Dec 2001 20:06:09 -0800
Message-ID: <60360d48.0112312006.4a0d51cd@posting.google.com>

brian-l-smith_at_uiowa.edu (Brian Smith) wrote in message news:<60360d48.0112291928.2e7c5818_at_posting.google.com>...
> What is the rationale for having a UNIQUE constraint treat NULLS as
> equal?

I see I made a big mistake in not specifically refering to SQL database, and in particular the ANSI SQL standard. I was really just wanting to know the ANSI commitees rationale for this behavior. My guess is that the ANSI SQL commitee just standardized on what current implementations were doing at the time. Is my guess wrong?

Please keep in mind that I am asking about "SQL theory" not "relational theory".

Thanks,
Brian Received on Mon Dec 31 2001 - 22:06:09 CST