Re: jsonb and nested hstore

On 03/13/2014 06:53 AM, Greg Stark wrote:
>
> I also find it awkward that col->>'prop' returns the json
> representation of the property. If it's text that means it's
> double-quoted. I would think that a user storing text in a json
> property would want a way to pull out the text that json property
> represents so he doesn't have to write col->>'prop' = '"foo"' and
> doesn't need to strip the quotes (and de-escape the string?) before
> displaying the value or passing it through other apis.
>


->> returns dequoted text if the value it points to is a plain string. 
If it's not doing that then that's a bug.
   andrew=# select jsonb '{"a":"the string"}' -> 'a';       ?column?   --------------     "the string"   (1 row)
   andrew=# select jsonb '{"a":"the string"}' ->> 'a'   ;      ?column?   ------------     the string   (1 row)



cheers

andrew