On Sep 28, 2008, at 17:46, Tom Lane wrote:
> BTW, I think it is (or should be) possible to create an index on
> hstore->'mycol', so at least one of the reasons why you should *need*
> to switch to a "real" database column seems bogus.
The docs say:
<title>Indexes</title>
<para> <type>hstore</> has index support for <literal>@></> and
<literal>?</> operators. You can use either GiST or GIN index types. For
example: </para> <programlisting>
CREATE INDEX hidx ON testhstore USING GIST(h);
CREATE INDEX hidx ON testhstore USING GIN(h); </programlisting>
I'm not sure what that means. Can you create normal btree or hash
indexes on hstore columns? And is the index useful for both `@>` and `?
`?
Thanks,
David