Re: NULLS and User Input WAS Re: multimaster - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: NULLS and User Input WAS Re: multimaster
Date
Msg-id 20070604150712.GQ32320@phlogiston.dyndns.org
Whole thread Raw
In response to Re: NULLS and User Input WAS Re: multimaster  (Richard Huxton <dev@archonet.com>)
List pgsql-general
On Mon, Jun 04, 2007 at 03:38:01PM +0100, Richard Huxton wrote:
> Well, a strict "unknown" is fine - so long as it means just that.
>   How tall is Andrew? Unknown
>   How tall is Richard? Unknown
>   Are Andrew and Richard the same height? Unknown
>
> The problem is the slippery-slope from "unknown" to "not applicable" to
> "user refused to answer" to ...whatever

While you do well to point out that I have equivocated on "unknown"
(in my usual twitchy way whenever NULLs come up, I am told), your
example actually illustrates part of the problem.  There are NULLs
that are actually just local absences of data (you don't know how
tall I am), NULLs that are in fact cases of 'no such data' (the full
name that 'S' stands for in Harry S Truman -- Truman's middle name
was in fact just S), NULLs that are data nobody knows (unlike the
mere locally-unknown data: "When the tree fell in the woods with
nobody around to hear it, did it make a sound?"), and NULLs that are
the data in response to questions that can't be answered, ("What
exists after the end of the universe?")

See, this is what happens when you study the wrong things in school.
You start to think that logic and metaphysics are somehow related to
one another. :-/

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
The fact that technology doesn't work is no bar to success in the marketplace.
        --Philip Greenspun

pgsql-general by date:

Previous
From: "Steven De Vriendt"
Date:
Subject: Can someone have a look at my pg_hba.conf file ?
Next
From: Andrew Sullivan
Date:
Subject: Re: [Fwd: Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum]