On Sep 28, 2008, at 23:46, tomas@tuxteam.de wrote:
>> 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 `?`?
>
> That means that those operations are supported by a GiST (or GIN)
> index,
> that is:
>
> "find the records where col contains 'foo => 1, bar => 2'"
>
> is supported by the index. Likewise for "is contained in" and "has
> key".
> It's a bit like having mini-indexes on all keys (although I guess not
> that efficient). Pretty cool, I'd say.
Yeah, that does sound good. I look forward to having an excuse for
playing with this type…
Best,
David