numeric data type on 6.5
От | Tatsuo Ishii |
---|---|
Тема | numeric data type on 6.5 |
Дата | |
Msg-id | 199904270910.SAA16875@srapc451.sra.co.jp обсуждение исходный текст |
Ответы |
Re: [HACKERS] numeric data type on 6.5
|
Список | pgsql-hackers |
I thought numeric data type on 6.5 allows a very large precision. Am I missing something? -- Tatsuo Ishii test=> create table t1(n numeric(100,0)); CREATE test=> \d t1; Table = t1 +----------------------------------+----------------------------------+-------+ | Field | Type | Length| +----------------------------------+----------------------------------+-------+ | n | numeric | var | +----------------------------------+----------------------------------+-------+ test=> insert into t1 values(100000000000000000000000000000); NOTICE: Integer input '100000000000000000000000000000' is out of range; promoted to float INSERT 149033 1 test=> select * from t1; n - 1 (1 row)
В списке pgsql-hackers по дате отправления: