title: Update every value in an array in postgres json
body: <p>In my postgres database I have json that looks similar to this:</p>
  
  <pre><code>{
      "myArray": [
          {
              "myValue": 1
          },
          {
              "myValue": 2
          },
          {
              "myValue": 3
          }
      ]
  }
  </code></pre>
  
  <p>Now I want to rename <code>myValue</code> to <code>otherValue</code>. I can't be sure about the length of the array! Preferably I would like to use something like <code>set_jsonb</code> with a wildcard as the array index, but that does not seem to be supported. So what is the nicest solution?</p>