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

From Jan Wieck
Subject Re: NULL values or not?
Date
Msg-id 200112211229.fBLCTvD01601@saturn.jw.home
Whole thread Raw
In response to NULL values or not?  (Archibald Zimonyi <archie@netg.se>)
Responses Re: NULL values or not?
List pgsql-sql
Archibald Zimonyi wrote:
>
> Hi there,
>
> I have a question about NULL values. Lets say that we have a world with
> the following info:
>
> FirstName
> LastName
> PhoneNumber
>
>
> Everyone has to have a FirstName and LastName but not everyone has to have
> a PhoneNumber.
   I  don't  know  of any particular, but I can imagine cultures   where people don't have first or last names. For
surealot of   people  on this earth don't have a mailing address that'd fit   into the "usual" schema. Don't make the
schematoo  scattered   just  to  avoid  NULLs.  Wether  you like them or not doesn't   matter, use them where they are
handy.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com



pgsql-sql by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: should temporary tables show up in \dt as type "temporary" or as something?
Next
From: "Henshall, Stuart - WCP"
Date:
Subject: Re: Transaction and cascade problem