From: scott.marlowe <scott.marlowe@ihs.com>
To: Mike Sosteric <mikes@athabascau.ca>
Cc: pgsql-general@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] arrays
Date: Fri, 4 Oct 2002 10:08:54 -0600 (MDT)
Message-ID: <Pine.LNX.4.33.0210041008050.9386-100000@css120.ihs.com> (raw)
In-Reply-To: <Pine.SUN.3.96.1020929180740.10131E-100000@aupair.cs.athabascau.ca>
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.
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: scott.marlowe@ihs.com, mikes@athabascau.ca, pgsql-general@postgresql.org
Subject: Re: [SQL] arrays
In-Reply-To: <Pine.LNX.4.33.0210041008050.9386-100000@css120.ihs.com>
* 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