Re: [HACKERS] NUMERIC type conversions leave much to be desired

> 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