title: Is there a regexp_replace equivalent for postgresql 7.4?
body: <p>I'm trying to use <code>SELECT regexp_replace(m.*, '[\n\r]+', ' ', 'g')</code> to remove carriage returns and new lines from my field to generate a CSV from my table; however, looks like my postgresql version (7.4.27) does not support that function. </p>
  
  <blockquote>
    <p>function regexp_replace(members, "unknown", "unknown", "unknown") does not exist</p>
  </blockquote>
  
  <p>I also tried doing it this way: </p>
  
  <pre><code>SELECT replace(replace(m.*, '\r', ''), '\n', '')
  </code></pre>
  
  <blockquote>
    <p>function replace(members, "unknown", "unknown") does not exist</p>
    
    <p>No function matches the given name and argument types. You may need to add explicit type casts.</p>
  </blockquote>
  
  <p>or this way: </p>
  
  <pre><code>SELECT replace(replace(m.*, chr(13), ''), chr(10), '')
  </code></pre>
  
  <blockquote>
    <p>function replace(members, text, "unknown") does not exist</p>
  </blockquote>
  
  <p>and still got similar errors.  </p>
  
  <p>How can a achieve that using another function or solution?</p>