Re: question about hstore and indexes - Mailing list pgsql-general

Hi Andreas,

On 27/09/2013 09:24, Andreas Kretschmer wrote:
> This query can't use the index:
>
> test=*# explain select * from my_hstore where werte->'key1' = 'val1';
>                                   QUERY PLAN
> ------------------------------------------------------------------------------
>  Seq Scan on my_hstore  (cost=10000000000.00..10000000001.06 rows=1 width=36)
>    Filter: ((werte -> 'key1'::text) = 'val1'::text)
> (2 rows)

According to the docs:

hstore has GiST and GIN index support for the @>, ?, ?& and ?| operators

http://www.postgresql.org/docs/9.3/static/hstore.html


Cheers
--
Matteo Beccati

Development & Consulting - http://www.beccati.com/