title: Numeric overflow in insert query
body: <p>I am receiving an error of:</p>
  
  <blockquote>
    <p>Arithmetic overflow or division by zero has occurred. arithmetic
    exception, numeric overflow, or string truncation. numeric value is
    out of range.</p>
  </blockquote>
  
  <p>This can be replicated with:</p>
  
  <pre><code>create table testing (avalue numeric(3,2));
  </code></pre>
  
  <p>and the following insert:</p>
  
  <pre><code>insert into testing values (328);
  </code></pre>
  
  <p>However, using the following works fine:</p>
  
  <pre><code>insert into testing values (327);
  </code></pre>
  
  <p>328 seems to be the magic figure the error occurs.  To me, the <code>numeric(3,2)</code> declaration should allow me 000-999 with 2 decimal places but based on the above that is wrong.  </p>
  
  <p>Can someone explain why this is and what I should declare my domain as if I want to allow 0-999 with 2 decimal places as.</p>
  
  <p>Thanks</p>