title: PostgreSQL, How to re-cast a table column from Integer to Decimal?
body: <p>I'd like to alter a PostgreSQL column to convert from <code>integer</code> to <code>decimal</code>, setting all <code>integer</code> values to <code>&lt;value&gt;.0</code>.  How do I do this?</p>