Re: problem with precendence order in JSONB merge operator

On Tuesday, March 22, 2016, Peter Krauss <ppkrauss@gmail.com> wrote:

Subjective notes to contextualize (try to explain on bad-English) my "precedence order" and JSONB visions:

JSON datatype is perfect as workaround, and for many simple and less exigent applications.

JSONB is the  "first class" datatype for user community, we expected years (!) for it ... Need some "first class" and friendly behaviour. 

In this context JSONB is not "any other" datatype, it is the bridge between relational data and flexible data...

It is the Holy Grail and the Rosetta Stone :-) 

I think JSONB operators need some more attention, in semantic and usability contexts.   If you want to add  some friendliness and orthogonality in JSONB operators, will be natural to see -> operator as a kind of object-oriented path operator... 

By other hand, of course, you can do the simplest to implement JSONB... But you do a lot (!), it was not easy to arrive here, and need only a little bit more to  reach perfection ;-)

You are welcome to supply a patch for this particular "little bit" - but I suspect you will find it quite disruptive to backward compatibility and general system internals if you attempt to do so.  But maybe not.