Re: Precision problems with float8

On Fri, 9 Nov 2001, Gabriel Fernandez wrote:

> Hi,
>
> I send a week ago a mail and I have not get any answer.
>
> The main thing I want to know is: If I use the numeric type instead of
> float8 will it result in a slower overall performance or it won't be
> significantly different ?

Yes, it's almost certainly slower than float8, but I don't know how
significant it is (especially since you're already doing numeric<->
double precision conversions I think)

> (Of course, the initial 9.38 is the result of a previous calculation,
> rounded with two decimals places, but the only thing you can see in the
> value of the field is "9.38" ).
>
> Does anyone know the reason ?

Can you send a test script that generates a broken row?  I'm not sure
how to diagnose it from the information given.