Re: UNIQUE and NULL in SQL

Brian Smith wrote:

> What is the rationale for having a UNIQUE constraint treat NULLS as
> equal?

        No rationale at all... SQL NULLs are just an implementation hack. Cf Christopher J Date, Fabian Pascal, Hugh Darwen, Lee Fesperman and others -- check http://www.firstsql.com/dbdebunk/ and their books.

-- 
   _
  / \  Leandro Guimarães Faria Corsetti Dutra    +41 (21) 644 23 19
  \ /  http://homepage.mac.com./leandrod/        +41 (21) 216 15 93
   X   Orange Communications SA                  +55 (43) 322 89 71
  / \  Fita ASCII contra correio eletrônico HTML              Suíça