Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

If you are asking yourself the question how you can have support multiple meanings in a column, normalize. Then, baldness is just another value and you don't have to guess if the hair color is unknown, undefined, or missing.

On Jun 8, 2006, at 10:10 PM, Christopher Browne wrote:

A long time ago, in a galaxy far, far away, tshipley@xxxxxxxx (Trent Shipley) wrote:
On Thursday 2006-06-08 15:14, David Fetter wrote:
On Thu, Jun 08, 2006 at 05:21:07AM -0700, dananrg@xxxxxxxxx wrote:

on bag theory[1] and 3-value logic[2].  Until they come up with a
testable system, or Hell freezes over, whichever comes first,
Pascal's book will make a good companion on your shelf to books on
Phlogiston[3] theory, or a decent doorstop, whichever you prefer.

I have encountered at least two commercial database products that
declared every column "NOT NULL".  I have always assumed that this
was defensive, preventing stupid programmer mistakes.

I recall reading somewhere that Codd proposed multiple flavors of
nullity.  Are there theoretical proposals for databases with logical
systems having more than three values?

Darwen did a paper where he described how you'd cope with not having
any nulls.  It amounted to having a whole bunch of views that would
have a whole host of special indicator values to replace the multiple
meanings of NULL...
--
let name="cbbrowne" and tld="gmail.com" in String.concat "@" [name;tld];;
http://linuxdatabases.info/info/lisp.html
Including a destination in the CC list that will cause the recipients'
mailer to blow out is a good way to stifle dissent.
-- from the Symbolics Guidelines for Sending Mail

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
       message can get through to the mailing list cleanly

¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬
AgentM
agentm@xxxxxxxxxxxxxxxxxxxxx
¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux