On Mon, May 18, 2015 at 12:12 PM, Josh Berkus <josh@agliodbs.com> wrote:
> OK, you've flagellated this deceased equine enough that I'm calling the
> ASPCA. I get that you're unhappy that we don't have deep append.
> Everyone gets this. I simply don't care; shallow append is better than
> no append at all, and having shallow append does not block deep append
> from happening in 9.6.
I never expressed disagreement with having shallow append.
> The only question worth discussing is whether we change the operator to
> "+" (or, for that matter, something else). I've seen your vote on this,
> so, does anyone else have an opinion on "+" vs. "||"? Preferably with a
> justification with some kind of grounding?
My argument has very good grounding. The "||" UPDATE idiom from hstore
does not and cannot work in a practical way with jsonb's current ||
operator (at least for the large majority of use cases). It could, it
just doesn't. I don't want users to make the same association that I
did, which, based on the total lack of documentation for the new
operator, they easily could.
What is hard to understand about that?
--
Peter Geoghegan