Re: Does Codd's view of a relational database differ from that of Date&Darwin? [M.Gittens]

From: Jon Heggland <>
Date: Fri, 10 Jun 2005 09:42:28 +0200
Message-ID: <>

In article <AC5qe.11727$>, says...
> >> And x + NULL does not evaluate to NULL but x.
> >
> > I should have mentioned that I am talking about the SQL2 standard (or
> > SQL/92 or SQL:1992 or SQL-92 or whatever it is called). I am not
> > familiar with MS TSQL.
> It appears to be an ISO/ANSI SQL standard. SQL-99:

What does NULL + NULL evaluate to? NULL or 0?

How about the sum of an attribute of an empty relation? Or of a column with just NULLs?

How about NULL - NULL? And NULL = NULL? Is x = y and x - y = 0 equivalent (x and y being integer range variables)?

If you evaluate x + 0, will you get 0 if x is NULL, but x if it is not?

Received on Fri Jun 10 2005 - 09:42:28 CEST

Original text of this message