From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
---|---|
To: | hackers(at)postgresql(dot)org |
Subject: | numeric data type on 6.5 |
Date: | 1999-04-27 09:10:16 |
Message-ID: | 199904270910.SAA16875@srapc451.sra.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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)
From | Date | Subject | |
---|---|---|---|
Next Message | D'Arcy J.M. Cain | 1999-04-27 09:37:26 | Re: [HACKERS] numeric data type on 6.5 |
Previous Message | Jan Wieck | 1999-04-27 07:20:09 | Re: [HACKERS] views and group by (formerly: create view as selec |