Re: jsonb array-style subscripting

On 08/17/2015 02:18 PM, Jim Nasby wrote:
> On 8/17/15 3:33 PM, Josh Berkus wrote:
>> Again, how do we handle missing keys? Just return NULL? or ERROR? I'd
>> prefer the former, but there will be arguments the other way.
>
> I've been wondering if we should add some kind of "strict" JSON. My big
> concern is throwing an error if you try to provide duplicate keys, but
> it seems reasonable that json_strict would throw an error if you try to
> reference something that doesn't exist.

Only if there's demand for it. Is there?

>> array/key ambiguity is going to be painful.
>
> JSON keys are required to be strings, so maybe it's OK to differentiate
> based on whether the index is a string or a number. Or perhaps we use
> different nomenclature (ie: {} for objects).

Well, we did get rid of all of those implicit conversions for a reason.
So maybe that's good enough? i.e.

json['a']['b'][1] = 5
"assign 5 as the first element in the array 'b' of object 'a'"

json['a']['b']['1'] = 5
"assign 5 to key '1' of object 'b' of object 'a'"

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com