Re: proper use of array datatype

On 8/1/06, Nikolay Samokhvalov <samokhvalov@gmail.com> wrote:
> On 8/1/06, Eric Andrews <eric.m.andrews@gmail.com> wrote:
> > ... 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?
>
> What kind of content?
> Is it possible to design regular table for it (a set of properties is
> clear a priori)?

a set of ID numbers and no not really. the boxes are unique to a
destination and the content list/set is unique to the box. I'd have a
bajillion tables :(

> BTW, there is some interesting constrib module - contrib/hstore - that
> allows to work with structures similar to perl's hashes. And, one more
> - contrib/ltree - that provides the tree-like structures. Both are
> based on GiST - that means support of index and, therefore, good
> perfomance. Consider using these extensions.
id like to stay away from addons if i can avoid it you know?

thanks,
eric