title: Set-returning functions are not allowed in UPDATE when using Postgres 10
body: <p>We have an old Flyway database update </p>
  
  <pre><code>UPDATE plays SET album = (regexp_matches(album, '^6,(?:(.+),)?tv\d+'))[1]
  </code></pre>
  
  <p>...that runs fine with any Postgres version from 9.2 to 9.6 but fails with latest Postgres 10. Happens even when ran directly without any JDBC.</p>
  
  <pre><code>ERROR: set-returning functions are not allowed in UPDATE
  </code></pre>
  
  <p>Is there a backwards incompatibility I didn't notice from version 10 release notes? Is there a workaround?</p>