title: Comparing remove white spaces
body: <p>I have the float value to remove the white space from it.</p>
  
  <p>Here is the following is the example.</p>
  
  <p><strong>In SQL Server</strong>: In SQL Server I used the following script.</p>
  
  <pre><code>DECLARE @f1 FLOAT = 74.3658319091568;
  
  SELECT REPLACE(@f1,CHAR(160),'');
  </code></pre>
  
  <p>--Output</p>
  
  <pre><code>74.3658
  </code></pre>
  
  <p><strong>PostgreSQL</strong>: In postgresql I used the following script.</p>
  
  <pre><code>do
  $$
  DECLARE 
      v_f1 float = '74.3658319091568';
      v_f3 text;
  
  BEGIN
  
      SELECT regexp_replace(v_f1::varchar, '\s+$', '') INTO v_f3;
      Raise info '%',v_f3;
  
  END;
  $$   
  </code></pre>
  
  <p>--Output</p>
  
  <pre><code>INFO:  74.3658319091568 
  </code></pre>
  
  <p>I didn't get the result as I get in the SQL Server. </p>