Re: jsonb concatenate operator's semantics seem questionable

On 05/18/2015 08:57 AM, Ryan Pedela wrote:
> If not, deep concatenation would solve this problem, but I can also see
> another solution. Use + for shallow concatenation since it really means
> "add element to top-level path" as Peter suggests. Then add another
> function: jsonb_add( target jsonb, path text[], new jsonb ) to add
> element at any arbitrary path. Then leave || for deep concatenation in
> 9.6 or whenever.

Since swapping the operator seems still on the table, is there any
particular reason why you think "+" is more suited to shallow
concatination?  Both you and Peter have said this, but as a heavy user
of JSON/JSONB, to me it seems the other way around.  That is, "+" says
"add to arbitrary nested node" to me more than "||" does.

> If jsonb_replace() satisfies #4 then I think everything is fine. Without
> #4 however, jsonb would remain an incomplete document database solution
> in my opinion.

Oh, no question, we're still incomplete.  Aside from nested append, we
kinda lack easy sharded scale-out, which is a rather more major feature, no?