HN Explorer

5 comments

[ 3.5 ms ] story [ 19.1 ms ] thread
gjvc
especially in the price
samhithag
I know some spplications that just crashed due to incorrectly assuming trailing zeroes
schranz
Well, this behaviour of Oracle may be debatable too.

INSERT INTO test_number VALUES(10.0500);

SQL> SELECT * FROM test_number;

         I
---------- 10.05
avi_vallarapu
I think there is a way to get the inserted trailing zeroes in Oracle as well. So if you explicitly inserted 10.0500, you want to get 10.0500 but not 10.05 ?
avi_vallarapu
Anyways, I am more interested in how PostgreSQL can make us have trailing zeroes or no trailing zeroes depending on the type you choose or other work-arounds.