On 8/1/06, Eric Andrews <[EMAIL PROTECTED]> 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)?
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.
--
Best regards,
Nikolay
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
