title: replacing non-alphanumeric characters with a space, ignores quote in postgres?
body: <p>I want to replace all non alfanumeric characters in a field with spaces.</p>
  
  <pre><code>select 'Gishath, Sun''s Avatar', lower(regexp_replace('Gishath, Sun''s Avatar', '[^-a-zA-Z0-9_]+', ' '))
  </code></pre>
  
  <p>Im expecting the result to be <code>gishath sun s avatar</code> but is returning <code>gishath sun's avatar</code> instead. why?</p>