Re: jsonb and nested hstore

> select '{"a": 25}'::json->>'a' = '{"a": 25.0}'::json->>'a';
>   ?column?
> ----------
>   f

Although for development version of hstore (not a current version)
# select 'a=> 25'::hstore = 'a=> 25.0'::hstore; ?column?
---------- t

That is because compareJsonbValue compares numeric values with a help of 
numeric_cmp() instead of comparing text representation. This inconsistent will 
be fixed.


-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
  WWW: http://www.sigaev.ru/