Re: Does Codd's view of a relational database differ from that of Date&Darwin? [M.Gittens]
Date: Mon, 13 Jun 2005 10:17:46 +0200
In article <oFcqe.12059$F7.3016_at_news-server.bigpond.net.au>,
> > What does NULL + NULL evaluate to? NULL or 0?
> It's dependent upon the resident SET command and the
> data type of the operands. Here is the MS SQL ref,
This is just for strings. Does it have similar functionality for other data types?
Sheesh. I thought this was a bug in Oracle only. What if you want to actually store an empty string? Or is it just in this particular case that NULLs and empty strings are considered the same?
> > How about the sum of an attribute of an empty relation? Or of a column
> > with just NULLs?
> Dependent upon the SET command.
Even when no NULLs are involved, as in the empty relation?
-- JonReceived on Mon Jun 13 2005 - 10:17:46 CEST