numeric data type on 6.5

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)

Responses

Browse pgsql-hackers by date

  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