Re: [HACKERS] NUMERIC type conversions leave much to be desired - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: [HACKERS] NUMERIC type conversions leave much to be desired
Date
Msg-id 3733A5DE.DFD48372@alumni.caltech.edu
Whole thread Raw
In response to NUMERIC type conversions leave much to be desired  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] NUMERIC type conversions leave much to be desired  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> With fairly current sources:
<snip>
> ERROR:  overflow on numeric ABS(value) >= 10^1
>         for field with precision 31491 scale 52068

postgres=> create table dnum (f1 numeric(10,2));
postgres=> insert into dnum values ('12.34');
postgres=> insert into dnum values ('12.34'::numeric);
postgres=> insert into dnum values (12.34);
postgres=> insert into dnum values ('12.345');
postgres=> select * from dnum;  f1
-----
12.34
12.34
12.34
12.35
(4 rows)

fwiw, I've seen the same internal problems, and managed to fix them
with a full clean and reinstall. I'm probably a week old on my tree
vintage...
                  - Thomas

-- 
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California


pgsql-hackers by date:

Previous
From: Carlos Peralta Ramirez
Date:
Subject: Functions for arrays !!!!
Next
From: "Hiroshi Inoue"
Date:
Subject: MVCC vacuum error