From: Ludwig Lim <lud_nowhere_man@yahoo.com>
To: dev@archonet.com
Cc: PostgreSQL Mailing List <pgsql-sql@postgresql.org>
Subject: Re: RFC: A brief guide to nulls
Date: Wed, 15 Jan 2003 17:59:32 -0800 (PST)
Message-ID: <20030116015932.10944.qmail@web80304.mail.yahoo.com> (raw)
In-Reply-To: <1522.192.168.1.16.1042651389.squirrel@mainbox.archonet.com>
--- dev@archonet.com wrote:
> There have been a few posts recently where people
> have had problems with
> nulls. Anyone got comments on the below before I
> submit it to techdocs?
>
> TIA
>
> - Richard Huxton
>
> A Brief Guide to NULLs
> ======================
>
> What is a null?
> ===============
> A null is *not* an empty string.
> A null is *not* a value.
> A null is *not* a "special" value.
> A null is the absence of a value.
>
>
> What do nulls mean?
> ===================
> Well, they *should* mean one of two things:
> 1. There is no applicable value
> 2. There is a value but it is unknown
Good job!, it sure helps people who don't much
background on formal database theory.
What about adding this to the section "What does
nulls mean"
--> 3) No value has yet been assigned to that
particular attribute (field).
I think it would also be nice if you can add a
section on functions that deals with NULL such as
nullif() and coalesce(). These functions help users
interpret NULL values.
best regards,
ludwig
__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: lud_nowhere_man@yahoo.com, dev@archonet.com
Subject: Re: RFC: A brief guide to nulls
In-Reply-To: <20030116015932.10944.qmail@web80304.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox