| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | Mike Sosteric <mikes(at)athabascau(dot)ca> |
| Cc: | <pgsql-general(at)postgresql(dot)org>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: [SQL] arrays |
| Date: | 2002-10-04 16:08:54 |
| Message-ID: | Pine.LNX.4.33.0210041008050.9386-100000@css120.ihs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2002-10-04 16:13:12 | Re: Inheritance: delete parent deletes children |
| Previous Message | scott.marlowe | 2002-10-04 16:07:57 | Re: Deadlock |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-10-04 16:10:22 | Re: numeric hierarchy again (was Re: floor function in 7.3b2) |
| Previous Message | Tom Lane | 2002-10-04 16:08:29 | Re: Return of INSTEAD rules |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hans-Jürgen Schönig | 2002-10-04 16:30:47 | Re: [HACKERS] Large databases, performance |
| Previous Message | scott.marlowe | 2002-10-04 16:05:10 | Re: [HACKERS] Large databases, performance |