Re: [HACKERS] Numeric type - Mailing list pgsql-hackers

From Thomas G. Lockhart
Subject Re: [HACKERS] Numeric type
Date
Msg-id 36937DFF.14C5DEA4@alumni.caltech.edu
Whole thread Raw
In response to Re: [HACKERS] Numeric type  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: [HACKERS] Numeric type  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [HACKERS] Numeric type  (jwieck@debis.com (Jan Wieck))
Re: [HACKERS] Numeric type  (Bruce Momjian <maillist@candle.pha.pa.us>)
Re: [HACKERS] Numeric type  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-hackers
> > OK, I give up :) How do I use the numeric type?
> Works here.  Don't you hate when that happens:

postgres=> create table n1 (n numeric(10,5), d decimal(10,5));
CREATE
postgres=> insert into n1 values ('1.23456', '1.23456');
ERROR:  overflow on numeric       ABS(value) >= 10^0 for field with precision 2086 scale 53380

*sigh* 

Any hints on where to look? I did a CVSup update, then a "cvs -PdA" on
my development tree, a "make clean install" and an initdb. I did not try
a full clean checkout, but would think that it wouldn't help.

Anyone else running on Linux/i686/libc5 having success? If so, I'll go
back to working on outer joins...
                  - Tom


pgsql-hackers by date:

Previous
From: "Thomas G. Lockhart"
Date:
Subject: Re: [DOCS] Postgresql INSTALL-file & Windows
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Numeric type