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(at)alumni(dot)caltech(dot)edu
South Pasadena, California