Exasol supports approximate and exact numerical data types. The difference when using the approximate data types arises from the possible rounding differences, which can occur due to the type of storage and the way computations are performed. Information losses of this nature do not occur when using exact numeric types because of storage type.
| Data type | Range (min, max) | Precision | Note |
|---|---|---|---|
| Exact numeric type | |||
|
|
|
Precision, scale: (p,s) |
1 ≤
0 ≤
|
| Approximate numeric type | |||
|
|
|
~15 digits |
About 15 digits can be stored, independent of the scale. The special element The element |