Considering the peculiarities of storing floating-point numbers in a database, these data types are not recommended for storing monetary data. For the same reasons, columns with floating-point data are not recommended for use as keys or to have uniqueness constraints applied to them.

When using these data types in expressions, extreme care is advised regarding the rounding of evaluation results.

3.2.1. FLOAT

3.2.2. DOUBLE PRECISION

The DOUBLE PRECISION data type is stored with an approximate precision of 15 digits.