Re: BUG #11207: empty path will segfault jsonb #>

Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
> On 08/20/2014 07:30 PM, Tom Lane wrote:
>> 1. #> now returns the input object if the RHS array is empty;

> So will
> val #>> '{}'
> now return a dequoted bare scalar string? I think that's where the OP
> actually came into this.

Hm ... as the patch stands, you get the same thing from either operator:

regression=# select '"foo"'::json #> '{}';
?column?
----------
"foo"
(1 row)

regression=# select '"foo"'::json #>> '{}';
?column?
----------
"foo"
(1 row)

If you think the latter should be dequoted, we can probably make it so.
I'm not entirely convinced that's right though: you could argue that
dequoting is a function of the -> operator and we applied zero such
operators. (I'm not wedded to that argument, just raising it as food
for thought.) Comments?

regards, tom lane