Re: NULL values or not? - Mailing list pgsql-sql

From Andrew G. Hammond
Subject Re: NULL values or not?
Date
Msg-id 1009002775.1903.3.camel@xyzzy
Whole thread Raw
In response to NULL values or not?  (Archibald Zimonyi <archie@netg.se>)
List pgsql-sql
> As I wrote, I usually try to avoid NULL values, thus creating my tables as
> the first example. What kind of thumb rules do you use when it comes to
> NULL values? Again, I am referring to my vampire database which I named a
> few days ago (btw, without VACUUM the SELECT statement takes less then a
> second) and I am planning on making less tables where I can. But it still
> feels wrong to add NULL values when I can avoid them.

Using a seperate table for phone numbers makes sense if you need to keep
track of multiple phone numbers per person or multiple people per phone
number.  Otherwise it's pointless.  You add unnecessary and useless
complexity to your system.  Null values to indicate null data make
perfect sense.  I'm a strong believer in the KISS principal:

Keep It Short & Simple.

--
Andrew G. Hammond     mailto:drew@xyzzy.dhs.org
http://xyzzy.dhs.org/~drew/
56 2A 54 EF 19 C0 3B 43 72 69 5B E3 69 5B A1 1F
613-389-5481
5CD3 62B0 254B DEB1 86E0  8959 093E F70A B457 84B1
"To blow recursion you must first blow recur" -- me

pgsql-sql by date:

Previous
From: "Wei Weng"
Date:
Subject: Re: NULL values or not?
Next
From: Archibald Zimonyi
Date:
Subject: Re: NULL values or not?