Re: BUG #5797: Strange bug with hstore

"Maxim Boguk" <Maxim.Boguk@gmail.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