On 02/25/2015 03:13 AM, Thom Brown wrote:
> Can you think of a reasonable syntax for doing that via operators? I
> can imagine that as a json_path function, i.e.:
>
> jsonb_add_to_path(jsonb, text[], jsonb)
>
> or where the end of the path is an array:
>
> jsonb_add_to_path(jsonb, text[], text|int|float|bool)
>
> But I simply can't imagine an operator syntax which would make it clear
> what the user intended.
>
>
> No, there probably isn't a sane operator syntax for such an operation.
> A function would be nice. I'd just want to avoid hacking away at arrays
> by exploding them, adding a value then re-arraying them and replacing
> the value.
Well, anyway, that doesn't seem like a reason to block the patch.
Rather, it's a reason to create another one for 9.6 ...
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com