Re: So what's null then if it's not nothing?

David Cressey wrote:

> "Hugo Kornelis" <hugo_at_pe_NO_rFact.in_SPAM_fo> wrote in message
> news:8q8qn1pc1p66manifsnkvhas1u3dmi6gj0_at_4ax.com...
> > On 17 Nov 2005 14:08:15 -0800, michael_at_preece.net wrote:
> >
> > (snip)
> > > For us Pickies it's easy - null is
> > >equal to an empty string.
> >

>
> The best I can glean from what the Pickies have said in here, is that the
> issue of a cell with no value
> is moot in Pick, because the absence of a value can always be represented by
> the absence of the cell that might have held it.

The cell can and will be there - it's not absent - it's just empty.

> That's what I'm reading
> into what the Pickies wrote.
>
> This is not true in SQL, due to the fact that tables are rectangular, and
> data, for one reason or another, is stored in a form that's less than fully
> normalized.
>
> De gustibus non disputandum est.
Received on Fri Nov 18 2005 - 07:09:55 CET