Re: [BUGS] BUG #5797: Strange bug with hstore

2010-12-27 Thread Robert Haas
On Sun, Dec 26, 2010 at 12:29 AM, Maxim Boguk wrote: > On Tue, Dec 21, 2010 at 7:48 AM, Tom Lane wrote: >> "Maxim Boguk" writes: >>> Bad explain: >>> billing=# EXPLAIN SELECT * from domains where >>> name='"name"=>"somedomain"'::text::hstore->'name'; >>>                                          

Re: [BUGS] BUG #5797: Strange bug with hstore

2010-12-25 Thread Maxim Boguk
On Tue, Dec 21, 2010 at 7:48 AM, Tom Lane wrote: > "Maxim Boguk" writes: >> Bad explain: >> billing=# EXPLAIN SELECT * from domains where >> name='"name"=>"somedomain"'::text::hstore->'name'; >>                                              QUERY PLAN >> ---

Re: [BUGS] BUG #5797: Strange bug with hstore

2010-12-20 Thread Tom Lane
"Maxim Boguk" writes: > Bad explain: > billing=# EXPLAIN SELECT * from domains where > name='"name"=>"somedomain"'::text::hstore->'name'; > QUERY PLAN > > -

[BUGS] BUG #5797: Strange bug with hstore

2010-12-20 Thread Maxim Boguk
The following bug has been logged online: Bug reference: 5797 Logged by: Maxim Boguk Email address: maxim.bo...@gmail.com PostgreSQL version: 8.4.4 Operating system: Freebsd Description:Strange bug with hstore Details: One day ago I analyzed slow query for one of my