From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200209301609.g8UG9Ce23126@candle.pha.pa.us>
Subject: Re: [GENERAL] arrays
In-Reply-To: <3D983C90.7277.7FF06CB4@localhost>
To: Dan Langille <dan@langille.org>
Date: Mon, 30 Sep 2002 12:09:12 -0400 (EDT)
Cc: Josh Berkus <josh@agliodbs.com>,
	Mike Sosteric <mikes@athabascau.ca>, pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII

Dan Langille wrote:
> On 30 Sep 2002 at 8:54, Josh Berkus wrote:
> 
> > As such, I'd reccommend one of two approaches for you:
> > 
> > 1) Post some of your schema ideas here, and let us show you how they
> > are better done relationally.   The relational data model has 30 years
> > of thought behind it -- it can solve a lot of problems.
> 
> Mike,
> 
> Just in case you or others think Josh is some crazed lunatic[1] who 
> doesn't know what he's talking about, I support his views on this 
> topic.  Avoid arrays.  Normalize your data.
> 
> [1] - Actually, I don't think I know anything about Josh, except that 
> he's right about normalizing your data.

Yes, arrays have a very small window of usefulness, but the window does
exist, so we haven't removed them.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073