[GENERAL] question about hstore and indexes

2013-09-27 Thread Andreas Kretschmer
Hi @all, i have this table with some rows: test=*# \d my_hstore; Table public.my_hstore Column | Type | Modifiers +-+ id | integer | not null default

Re: [GENERAL] question about hstore and indexes

2013-09-27 Thread Matteo Beccati
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

Re: [GENERAL] question about hstore and indexes

2013-09-27 Thread Andreas Kretschmer
Matteo Beccati p...@beccati.com wrote: 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