Re: [HACKERS] numeric data type on 6.5

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.