Re: [HACKERS] numeric data type on 6.5
От
Tatsuo Ishii
Тема
Re: [HACKERS] numeric data type on 6.5
Дата
Msg-id
199904270948.SAA23721@srapc451.sra.co.jp
Ответ на
Re: [HACKERS] numeric data type on 6.5 (D'Arcy J.M. Cain)
Список
Дерево обсуждения
Re: [HACKERS] numeric data type on 6.5 Thomas Lockhart <lockhart@alumni.caltech.edu>
>> 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
В списке pgsql-hackers по дате отправления
