Re: [HACKERS] numeric data type on 6.5 - Mailing list pgsql-hackers

>> 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);

Thanks. It definitely works!
--
Tatsuo Ishii