[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-hackers
Subject:    Re: [HACKERS] Ad-hoc table type?
From:       "David E. Wheeler" <david () kineticode ! com>
Date:       2008-09-29 16:08:09
Message-ID: E50E3E37-9117-451F-A8B3-D0EB425F2E3E () kineticode ! com
[Download RAW message or body]

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


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

[prev in list] [next in list] [prev in thread] [next in thread]