title: Error: invalid input syntax for type numeric: "" (postgresql)
body: <p>I'm trying to alter the column data type in my postgresql table. The column name is <code>_2010_10</code>, type is text, and the value is 18.74 (in text format). I'm trying to change the text type to numeric. This is my input/output:</p>
  
  <pre><code>ALTER table cadata.pricetorentratio 
  ALTER column _2010_10 type numeric USING (trim(_2010_10)::numeric);
  </code></pre>
  
  <blockquote>
    <p>ERROR: invalid input syntax for type numeric: "" </p>
  </blockquote>
  
  <p>Not sure why I'm getting this error.</p>