| From: | "Eric Andrews" <eric(dot)m(dot)andrews(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | proper use of array datatype |
| Date: | 2006-08-01 18:58:00 |
| Message-ID: | 7a4707ef0608011158u14aa1408s6b918b2bc10ac3a9@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
hello all,
I am not much of a schema designer and have a general questoin about
the proper use of the array datatype. In my example, I have
destinations, and destinations can have multiple boxes, and inside
those boxes are a set of contents. what I want to do is search and
basically "mine" data from the content sets. do I use an array
datatype for the content column, or is there a better more efficient
way to go about this?
>From http://www.postgresql.org/docs/8.1/interactive/arrays.html
Tip: Arrays are not sets; searching for specific array elements may
be a sign of database misdesign. Consider using a separate table with
a row for each item that would be an array element. This will be
easier to search, and is likely to scale up better to large numbers of
elements.
thanks,
eric
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2006-08-01 19:00:35 | Re: Can you run out of oids? |
| Previous Message | Ian Harding | 2006-08-01 18:49:08 | Re: Where do Tcl questions go? |