"Maxim Boguk" <Maxim(dot)Boguk(at)gmail(dot)com> writes:
> Bad explain:
> billing=# EXPLAIN SELECT * from domains where
> name='"name"=>"somedomain"'::text::hstore->'name';
> QUERY PLAN
> ----------------------------------------------------------------------------
> ------------------------
> Seq Scan on domains (cost=0.00..7775.91 rows=1 width=230)
> Filter: ((name)::text = (('"name"=>"somedomain"'::text)::hstore ->
> 'name'::text))
> (index not used)
The reason for this is that hstore fails to label its I/O functions as
immutable (or even stable) in 8.4. This is fixed in 9.0.
regards, tom lane