numeric data type on 6.5 - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject numeric data type on 6.5
Date
Msg-id 199904270910.SAA16875@srapc451.sra.co.jp
Whole thread Raw
Responses Re: [HACKERS] numeric data type on 6.5  ("D'Arcy" "J.M." Cain <darcy@druid.net>)
List 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 by date:

Previous
From: José Soares
Date:
Subject: Re: [HACKERS] psql bug ?
Next
From: "D'Arcy" "J.M." Cain
Date:
Subject: Re: [HACKERS] numeric data type on 6.5