title: PostgreSQL various clean up of string \ varchar
body: <p>I have to clean up some varchar in the following manner:</p>
  
  <ol>
  <li><p>Remove special characters such as: <code>!, @, #, $, %, ^, &amp;, *, (, ), }, {, [, ], ",", ., ?, /, ',</code> from a closed list. I've managed to do so with a mass use of replace\regexp_replace but I'm looking for something similar to the one in SQL server.</p></li>
  <li><p>Remove following numbers but not adjacent ones meaning:</p>
  
  <p><code>round 1 --&gt; round</code><br/>
  <code>round1 --&gt; round1</code><br/>
  <code>round 12345 --&gt; round</code><br/>
  <code>round12345 --&gt; round12345</code></p></li>
  <li><p>Remove words out of a closed list of words such as: <strong>"and", "or", "Ltd.", "international"</strong> without substrings:</p>
  
  <p><code>more food or drinks ---&gt; more food drinks. and not --&gt; me food or drinks</code></p></li>
  </ol>
  
  <p>I'm working on a big table and I'd like to do it as efficient as possible.<br>
  Should I write a function that does that or is there a more elegant way?</p>