Data Types and Supported Operations

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.

Table 1. Data Types and Supported Operations
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