title: How can I assign a data type decimal to a column in Postgresql?
body: <p>I'm working with postgresql-9.1 recently.</p>
  
  <p>For some reason I have to use a tech which does not support data type numeric but decimal. Unfortunately, the data type of columns which I've assigned decimal to them in my Postgresql are always numeric. I tried to alter the type, but it did not work though I've got the messages just like "Query returned successfully with no result in 12 ms".</p>
  
  <p>SO, I want to know how can I get the columns to be decimal.</p>
  
  <p>Any help will be highly appreciate.</p>
  
  <p>e.g.</p>
  
  <p>My creating clauses:</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS htest
  (
    dsizemin decimal(8,3) NOT NULL,
    dsizemax decimal(8,3) NOT NULL,
    hidentifier character varying(10) NOT NULL,
    tgrade character varying(10) NOT NULL,
    fdvalue decimal(8,3),
    CONSTRAINT htest_pkey PRIMARY KEY (dsizemin , dsizemax , hidentifier , tgrade )
  );
  </code></pre>
  
  <p>My altering clauses:</p>
  
  <pre><code>ALTER TABLE htest
  ALTER COLUMN dsizemin TYPE decimal(8,3);
  </code></pre>
  
  <p>But it does not work.</p>