Re: NULLs
From: David Cressey <cressey73_at_verizon.net>
Date: Wed, 26 Dec 2007 17:47:21 GMT
Message-ID: <Jswcj.4730$Pt6.4162_at_trndny07>
Date: Wed, 26 Dec 2007 17:47:21 GMT
Message-ID: <Jswcj.4730$Pt6.4162_at_trndny07>
"stevedtrm" <stevedtrm_at_hotmail.com> wrote in message
news:4afba236-4273-4d24-b8f4-5041483d22fc_at_i12g2000prf.googlegroups.com...
> What are NULLs for?
>
> Missing information? Then surely there should just be no tuple?
>
> To indicate that there can be no value? Why not a seperate table with
> a boolean value in the non-key column?
>
> Steve B.
Go to google groups. Select the newsgroup comp.databases.theory
Do a search on NULLS. You will find a multitude of discussions about NULLS.
almost everything that this discussion might produce has been said in at
least one of those discussions.
Short answer: yes, it is to indicate that there is no value.