title: SQL : create column with default value 0.00
body: <p>I am trying to create a new column called <code>credit</code>, whose default value should be <code>0.00</code>
  I am in PSQL postgres so I tried doing:</p>
  
  <pre><code>ALTER TABLE table_name
  ADD credit FLOAT(2) DEFAULT '0.00';
  </code></pre>
  
  <p>But the column just shows <code>0</code> and not <code>0.00</code></p>
  
  <p>I tried doing  <code>ADD credit FLOAT(10,2) DEFAULT '0.00';</code> 
  but this does not compile</p>