title: postgresql store decimal value with trailing zero using type real
body: <p>i'm new to sql and trying to store a decimal value so that it gets stored truly as "6.0". for example,  </p>
  
  <pre><code>INSERT INTO public.mytable(the_num) VALUES (6.0)
  </code></pre>
  
  <p>but the result is storing as "6" instead of "6.0" , of course any non-zero number like 6.1 or 6.5 is stored fine. </p>
  
  <p>how can I store the value without having the trailing zero truncated ? is there some other data type i should be using? </p>