The operations that are explicitly supported between the data types are detailed in the table below.
It is possible to perform operations between the data types not listed in the table if the underlying data type of an attribute can be converted into one of the types for which an operation is supported.
For example, the addition of IEG_INT8 and IEG_MONEY is possible, because IEG_INT8 is converted into IEG_DOUBLE and the addition of IEG_DOUBLE and IEG_MONEY is supported.
It is possible to add or subtract integers from dates. Integers represent the number of days to be added or subtracted.
The first parameter type |
The second parameter type |
Operations supported |
Result type |
---|---|---|---|
IEG_STRING |
IEG_STRING |
==, != |
IEG_BOOLEAN |
IEG_CHAR |
IEG_CHAR |
==, != |
IEG_BOOLEAN |
IEG_MONEY |
IEG_MONEY |
==, !=, <, >, <=, >= |
IEG_BOOLEAN |
IEG_MONEY |
IEG_DOUBLE |
==, !=, <, >, <=, >= |
IEG_BOOLEAN |
IEG_DOUBLE |
IEG_MONEY |
==, !=, <, >, <=, >= |
IEG_BOOLEAN |
IEG_DOUBLE |
IEG_DOUBLE |
==, !=, <, >, <=, >= |
IEG_BOOLEAN |
IEG_DATE |
IEG_DATE |
==, !=, <, >, <=, >= |
IEG_BOOLEAN |
IEG_MONEY |
IEG_MONEY |
+, -, /, * |
IEG_DOUBLE |
IEG_MONEY |
IEG_DOUBLE |
+, -, /, * |
IEG_DOUBLE |
IEG_DOUBLE |
IEG_MONEY |
+, -, /, * |
IEG_DOUBLE |
IEG_DOUBLE |
IEG_DOUBLE |
+, -, /, * |
IEG_DOUBLE |
IEG_FLOAT |
IEG_FLOAT |
+, -, /, * |
IEG_DOUBLE |
IEG_INT8 |
IEG_INT8 |
+, -, /, * |
IEG_INT32 |
IEG_INT16 |
IEG_INT16 |
+, -, /, * |
IEG_INT32 |
IEG_INT32 |
IEG_INT32 |
+, -, /, * |
IEG_INT32 |
IEG_INT64 |
IEG_INT64 |
+, -, /, * |
IEG_INT64 |
IEG_DATE |
IEG_INT32 |
+, - |
IEG_DATE |