Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP
	id 342FB4770A5; Fri,  4 Oct 2002 12:17:46 -0400 (EDT)
Received: from mail1.ihs.com (mail1.ihs.com [170.207.70.222])
	by postgresql.org (Postfix) with ESMTP
	id 3F25347728B; Fri,  4 Oct 2002 12:17:22 -0400 (EDT)
Received: from css120.ihs.com (css120.ihs.com [170.207.105.120])
	by mail1.ihs.com (8.12.6/8.12.6) with ESMTP id g94GGhS5012273;
	Fri, 4 Oct 2002 10:16:43 -0600 (MDT)
Date: Fri, 4 Oct 2002 10:08:54 -0600 (MDT)
From: "scott.marlowe" <scott.marlowe@ihs.com>
To: Mike Sosteric <mikes@athabascau.ca>
Cc: <pgsql-general@postgresql.org>, <pgsql-sql@postgresql.org>
Subject: Re: [SQL] arrays
In-Reply-To: 
 <Pine.SUN.3.96.1020929180740.10131E-100000@aupair.cs.athabascau.ca>
Message-ID: <Pine.LNX.4.33.0210041008050.9386-100000@css120.ihs.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-MailBodyFilter: Message body has not been filtered
X-MailScanner: Found to be clean
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200210/259
X-Sequence-Number: 31257

On Sun, 29 Sep 2002, Mike Sosteric wrote:

> On Sun, 29 Sep 2002, Bruce Momjian wrote:
> 
> Apologies in advance if there is a more appropriate list. 
> 
> We are currently developing a database to host some complicated, XMl
> layered data. We have chosen postgres because of its ability to store
> multidimensional arrays. We feel that using these will allow us to
> simplify the database structure considerably by storing some data in
> multidimensional arrays. 

the long and the short of it is that arrays are useful to store data, but 
should not be used where you need to look up the data in them in a where 
clause.