On Sep 28, 2008, at 23:46, [EMAIL PROTECTED] 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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers