Thus spake Tatsuo Ishii
> I thought numeric data type on 6.5 allows a very large precision. Am I
> missing something?
[...]
> test=> insert into t1 values(100000000000000000000000000000);
> NOTICE: Integer input '100000000000000000000000000000' is out of range; promoted to float
Try this.
insert into t1 values('100000000000000000000000000000'::numeric);
--
D'Arcy J.M. Cain <darcy@{druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 424 2871 (DoD#0082) (eNTP) | what's for dinner.