postgres=# CREATE TABLE numbers ( postgres(# number int postgres(# ); CREATE TABLE postgres=# postgres=# INSERT INTO numbers VALUES (trunc(99999.99999999, 6)); INSERT 0 1 postgres=# postgres=# SELECT * FROM numbers; number -------- 100000 (1 row) postgres=# postgres=# postgres=# drop table numbers; DROP TABLE postgres=#