title: Float on PostgreSQL using c#
body: <p>Im using this </p>
  
  <p>this is the data type im sending in the cmd:</p>
  
  <blockquote>
    <p>NpgsqlTypes.NpgsqlDbType.Real;</p>
  </blockquote>
  
  <p>here im cheking that is a numeric value:</p>
  
  <blockquote>
  <pre><code>   public bool IsNumeric(String value){
          try{
              float.Parse(value);
              return true;
          }
          catch(Exception e){
              return false;
          }
      }
  </code></pre>
  </blockquote>
  
  <p>And here is the alter table:</p>
  
  <blockquote>
    <p>ALTER TABLE "Medicine" ADD COLUMN "Price" real;
    ALTER TABLE "Medicine" ALTER COLUMN "Price" SET NOT NULL;</p>
  </blockquote>
  
  <p>The table data type is Real too, thats how i can save "float" cuz it seen that PostgreSQL doesnt have a float. Ive tried with double, money, numeric, and still doesnt work. The numbers is inserted in the table, but w/o the ".", for example, i writte 12.34 and 1234 is inserted. Already checked everything when debugging.</p>
  
  <p>How can i solve this?</p>