title: PostgreSQL replace range of unicode chars
body: <p>I have some problems with characters not allowed in XML-export. The request is simply to remove the invalid characters from the text to ensure corrext export/import of data.</p>
  
  <p>so far, thanks to <a href="https://stackoverflow.com/questions/15190078/replace-unicode-characters-in-postgresql">this post</a> I have an sql statement which replaces one declared Unicode char:</p>
  
  <pre><code>UPDATE mytable SET myproperty = replace(myproperty, U&amp;'\UNICODE', '');
  </code></pre>
  
  <p>It removes the specified Unicode from all occurrences inside the defined cell. But I would like to give a bunch of Unicode chars to be replaced, eg. 0x1 - 0xf
  Does anybody have an idea how to achieve that?</p>