Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 26 Dec 2007 @ 08:43:02 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


Subj:   Re: Row CheckSum
 
From:   frank.c.martinez

Sigh... "It is beyond me why Teradata (and other database vendors) cannot update their technology to handle null equality operations."

It's not a technical question. I'm sure there's a technical way that even my Java programmer friends could figure out (hah! Teasing!) Or actually several technical ways. But NULL means Unknown. And there's no way to know if one unknown is equal to another unknown. X=Y? Just by itself, there ain't no way. This is a theoretical argument that involves the definition of NULL in the SQL standard. We could get into Codd's discussion on p'haps SQL is deficient 'cause you can't specify different kinds of NULL's. Like for instance, the unknown color of someone's eyes versus the not-applicable color of the eyes of a car.

But I brought this all up just to give you something to think about and realize that yes, Santa Claus is a real possibility. After all, the square root of negative one is a actual value that is used to measure phenomena. So anyway, Happy Holidays to everyone!


iv



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023