home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 1,878 of 2,288   
   Frank Piron to All   
   Re: Unique constraint and NULL values   
   22 Oct 04 15:50:42   
   
   XPost: comp.databases.oracle.misc, comp.databases.oracle.server   
   From: empty@zero.nil   
      
   Am Fri, 22 Oct 2004 08:33:52 -0500 schrieb Turkbear   
   :   
   > It can get almost metaphysical, but:   
   > Identifying a column which has an undeterminable value ( NULL) is not   
   > the same as identifying that value, so being able to   
   > consider  that column unique ( that is , it is the only one with the   
   > undeterminable value) is not a problem.   
   >   
      
   The difference you point to is clear for me.   
   But i did not find a real world example for   
   a column which is unique in a table and at   
   most one row with a NULL value for this column   
   should be allowed.   
      
   --   
   Frank Piron,   
   etfrankatkonaddotn   
   (leftrotate two)   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca