Re: [GENERAL] arrays
Bruce Momjian <pgman@candle.pha.pa.us>
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Dan Langille <dan@langille.org>
Cc: Josh Berkus <josh@agliodbs.com>, Mike Sosteric <mikes@athabascau.ca>, pgsql-sql@postgresql.org
Date: 2002-09-30T16:09:12Z
Lists: pgsql-hackers, pgsql-general, pgsql-sql
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