Re: [HACKERS] numeric data type on 6.5

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: hackers(at)postgreSQL(dot)org
Cc: t-ishii(at)sra(dot)co(dot)jp (Tatsuo Ishii)
Subject: Re: [HACKERS] numeric data type on 6.5
Date: 1999-04-27 09:48:04
Message-ID: 199904270948.SAA23721@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?
>[...]
>> 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Mount 1999-04-27 09:52:06 RE: [INTERFACES] JDBC and waiting for commit on a locked table in 6.4.2
Previous Message D'Arcy J.M. Cain 1999-04-27 09:37:26 Re: [HACKERS] numeric data type on 6.5