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

> > 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...
> Good thought but no cigar ... I did a full fresh CVS checkout, configure,
> make, install & initdb from scratch, and it still behaves the same.
> Possibly it's been broken sometime in the last week? utils/adt/numeric.c
> looks to have been last committed on 4 May.

No, those changes were actually by myself, and just modified one line
in the float8->numeric conversion code to use a direct sprintf("%f")
to convert float8 to a string in preparation for conversion to
numeric. The old code used the float8out() routine, which for larger
floats generated exponential notation that the numeric_in() routine
wasn't prepared to handle.

I've seen the same problems you are having, and reported them just as
you have ("something is fundamentally wrong with numeric..."). And
then the problems went away, but I'm not actually certain why.

Let me know if I can help track it down, since others might get bit
too...

- Tom

--
Thomas Lockhart lockhart(at)alumni(dot)caltech(dot)edu
South Pasadena, California