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>@></> 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