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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
