peter_nn0 wrote:

> I have in some tables fields of type FLOAT which are filled by stored
> procedures.
> Now the values in these fields are stored with tons of digits after the
> decimal point, like 12.1234567890123
> I do not need and want to avoid this, would like to have not more than
> 3 digits after the decimal point - like 12.123

Well, the right thing to do is to use a numeric type with a specific
precision - e.g. numeric (9, 3). Float is not a great type for
anything that can be counted - it's more of a measurement thing where
you want the measurement of something that exists to be as close as
possible to its actual dimension.


Regards,


Ann