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=#