pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Dan Langille <dan@langille.org>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: Mike Sosteric <mikes@athabascau.ca>
Cc: pgsql-sql@postgresql.org
Subject: Re: [GENERAL] arrays
Date: Mon, 30 Sep 2002 12:10:29 -0400
Message-ID: <3D983F35.27949.7FFAC443@localhost> (raw)
In-Reply-To: <200209301609.g8UG9Ce23126@candle.pha.pa.us>
References: <3D983C90.7277.7FF06CB4@localhost>

On 30 Sep 2002 at 12:09, Bruce Momjian wrote:

> 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.

I do not advocate removing them.  I do advocate data normalization. 
Let's say it's a matter of Do The Right Thing(tm) unless you know 
what you're doing.
-- 
Dan Langille
I'm looking for a computer job:
http://www.freebsddiary.org/dan_langille.php




view thread (36+ messages)  latest in thread

Message-ID: <3D983F35.27949.7FFAC443@localhost>
Permalink:  ../3D983F35.27949.7FFAC443@localhost/
Also on:    postgresql.org/message-id/3D983F35.27949.7FFAC443@localhost

 · 

reply
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: dan@langille.org, pgman@candle.pha.pa.us, josh@agliodbs.com, mikes@athabascau.ca
  Subject: Re: [GENERAL] arrays
  In-Reply-To: <3D983F35.27949.7FFAC443@localhost>

* 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