ESQL numeric data types
ESQL supports several data types that handle numeric values,
including DECIMAL, FLOAT, and INTEGER.
The following data types are collectively known as numeric data
types:
Notes: - INTEGER and DECIMAL types are represented exactly inside the integration
node; FLOAT types are inherently subject to rounding error without
warning. Do not use FLOAT if you need absolute accuracy, for example,
to represent money.
- Various casts are possible between different numeric types. These
can result in loss of precision, if exact types are cast into FLOAT.
For information about numeric functions see ESQL numeric functions.