IssueRaiser

> If we can address fields with operators (->, ->>, etc.) then why can't those operators modify, too?

> If we can address fields with operators (->, ->>, etc.) then why can't those operators modify, too? It works for everything else, after all. It's fairly counter-intuitive from a dev perspective. It certainly doesn't work for "everything else". You can update individual "parts" of arrays and record types, that's it. And those exception are hard-coded, so someone would either have to hard-code similar exceptions for JSON values (ugly, inflexible, generally a bad idea) or generalize support for custom operators on the left-hand side of assignments in UPDATE. All this while trying to push out a release which was already late by months . You can call everything an oversight, but with very limited resources available and the need to cut a release at some point, this is far from the truth in this case.

Posted by nunwuo on Apr 20, 2015, 2:38 PM

Tags

Related issues

Raise real-world problems, find people facing the same issue, and discuss solutions.7,000 issues0 comments

support (Software)

> If we can address fields with operators (->, ->>, etc.) then why can't those operators modify, too?

nunwuoApr 20, 2015, 2:38 PM

> If we can address fields with operators (->, ->>, etc.) then why can't those operators modify, too? It works for everything else, after all. It's fairly counter-intuitive from a dev perspective. It certainly doesn't work for "everything else". You can update individual "parts" of arrays and record types, that's it. And those exception are hard-coded, so someone would either have to hard-code similar exceptions for JSON values (ugly, inflexible, generally a bad idea) or generalize support for custom operators on the left-hand side of assignments in UPDATE. All this while trying to push out a release which was already late by months . You can call everything an oversight, but with very limited resources available and the need to cut a release at some point, this is far from the truth in this case.

Comments (0)

No comments yet. Start the discussion.

Comment on this issue