Type Decimal doesn't work in Amazon Redshift
<p>I created a table in Redshift:</p>

<pre><code>CREATE TABLE test_table1 (
  id bigint NOT NULL,
  longitude decimal(6,4)
);
</code></pre>

<p>and inserted:</p>

<pre><code>INSERT INTO test_table1 VALUES (1, 65.3695);
</code></pre>

<p>yet querying the database shows <code>(1, 65.37)</code> </p>

<p><img src="https://i.stack.imgur.com/1ZggN.png" alt="see an image here"></p>

<p>Why isn't the result:  <code>1, 65.3695</code>?</p>