Re: Ad-hoc table type?

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>@&gt;</> 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