Re: [GENERAL] arrays - Mailing list pgsql-sql

From scott.marlowe
Subject Re: [GENERAL] arrays
Date
Msg-id Pine.LNX.4.33.0210041008050.9386-100000@css120.ihs.com
Whole thread Raw
In response to Re: [GENERAL] arrays  (Mike Sosteric <mikes@athabascau.ca>)
List pgsql-sql
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.


pgsql-sql by date:

Previous
From: "Brian Ward"
Date:
Subject: Need some SQL help
Next
From: Larry Rosenman
Date:
Subject: Re: timestamp