Re: Do we really need NULL??

In article <3a2b3i$cse_at_mercury.kingston.ac.uk> k920699_at_kingston.ac.uk (Sean Batten) writes:
>What are the advantages and disadvantages of using NULL?
>
Among other things, to represent a missing value. If you are going to work with a group of values, you need to be able to ignore the missing values.

The averages of the following sets are quite different:

1 2 3 4 missing missing missing missing missing missing = 10/4

1 2 3 4 0 0 0 0 0 0 = 1

Read some relational theory texts for more in depth discussions of null.

-- 
Joel Garry           joelga_at_amber.rossinc.com            Compuserve 70661,1534
These are my opinions, not necessarily those of Ross Systems, Inc.
%DCL-W-SOFTONEDGEDONTPUSH, Software On Edge - Don't Push.  
panic: ifree: freeing free inodes...