Hi Steffen,

> I use INTEGER, counted in Cent.
> (Anyway, the main reason is to be able to multiply and add them without
> having to think about rounding, (as I do this in Java and afaik Numeric and
> Double need to be taken as floats))

This is not true. NUMERIC is a fixed-decimal datatype and not
a float.

Here is an exerpt from the Data Definition Guide:

- NUMERIC and DECIMAL datatypes that are declared without either
precision or scale are stored as INTEGER.

- Defined with precision, with or without scale, they are stored
as SMALLINT, INTEGER, DOUBLE PRECISION or 64-bit integer. Storage
type depends on both the precision and the dialect of the database.

So one does not be afraid of NUMERIC as currency type.


Christian