Re: Fabian Pascal and RDBMS deficiencies in fully implementing the relational model

From: David Fetter <david(at)fetter(dot)org>
To: Agent M <agentm(at)themactionfaction(dot)com>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Fabian Pascal and RDBMS deficiencies in fully implementing the relational model
Date: 2006-06-09 15:45:59
Message-ID: 20060609154559.GB24820@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Fri, Jun 09, 2006 at 05:20:46PM +0200, Martijn van Oosterhout wrote:
> On Fri, Jun 09, 2006 at 07:09:12AM -0400, Agent M wrote:
> > Well, the Date argument against NULLs (and he never endorsed them,
> > or so he claims) is that they are not data- they represent the
> > absence of data- so why put non-data in a _data_base.
>
> At this point you could start a whole philosophical discussion about
> whether knowing you don't know something is a fact worth storing.

And to me, the answer is an unqualified "yes." A state of ignorance
is an important piece of information by itself.

For example, that I don't know someone's birthdate is important. When
I'm trying to figure out when to send a birthday card, knowing that I
don't know this piece of information means that I take a different
action "decide whether to try to find out what the birthdate is." from
the action I would take if I didn't know that I don't know the
birthdate, which is "rummage through all my records trying to find the
birthdate."

Cheers,
D
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter

Remember to vote!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A.M. 2006-06-09 16:01:07 Re: Fabian Pascal and RDBMS deficiencies in fully
Previous Message David Fetter 2006-06-09 15:40:52 Re: Fabian Pascal and RDBMS deficiencies in fully implementing

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-06-09 15:49:03 Re: That EXPLAIN ANALYZE patch still needs work
Previous Message David Fetter 2006-06-09 15:40:52 Re: Fabian Pascal and RDBMS deficiencies in fully implementing