hi<br />some time ago i was told on postgresql-general about existence of "hstore" package for postgresql.<br />as i
understandit is being developed by the same guys that are behind tsearch2, gin and (at least) recent changes in gist.
<br/><br />would it be possible to include this software in main postgresql tarball? it would be best if it came as
standardfeature, but contrib module would also work.<br /><br />if you are not familiar with hstore - this is new
datatypefor postgresql which allows you to store (and browse and search) any number of pairs of (key, value) in one
field.<br /><br />i have number of projects coming to my mind which could take advantage of something like this. the
simplestthing is e-commerce site, where all custom fields (fields dependand on product type) can be stored in one,
easilyretrievable, field - thus reducing database load by skipping additional table scans for custom field table(s).
<br/><br />if you would like to check it: url is: <a
href="http://www.sai.msu.su/~megera/postgres/gist/hstore/README.hstore">http://www.sai.msu.su/~megera/postgres/gist/hstore/README.hstore</a>,
andthe software itself is downloadable from <a
href="http://www.sai.msu.su/~megera/postgres/gist/">http://www.sai.msu.su/~megera/postgres/gist/</a><br/><br />best
regards<br/><br />hubert<br /><br />