If you overload function names, and the functions pass the same number of parameters, you must define the functions so that the parameter data types are distinct from each other. Use the following table to help you identify data types that are distinct from each other.
| Types | Rules |
|---|---|
| Numeric | The following numeric types are distinct from each other, and from other data types:
DECIMAL, NUMERIC, or NUMBER types that differ in size are not distinct. For example, DECIMAL(6,2) and DECIMAL(8,3) are not distinct. |
| DateTime | The following DateTime types are distinct from each other, and from other data types:
TIME, TIMESTAMP, and INTERVAL types that differ in precision or fractional seconds precision are not distinct. For example, TIME(2) and TIME(6) are not distinct. |
| Character | The following character types are distinct from each other, and from other data types:
Character strings that differ in length are not distinct. For example, CHAR(10) and CHAR(5) are not distinct. Character strings that specify different server character sets in the CHARACTER SET phrase are not distinct. |
| Byte | The following byte types are distinct from each other, and from other data types:
|
| Graphic | The following graphic types are distinct from each other, and from other data types:
|
| UDT | UDTs are distinct from other data types, including other UDTs. |
| Period | The following period types are distinct from each other, and from other data types:
PERIOD(TIME(n)), PERIOD(TIME(n) WITH TIME ZONE), PERIOD(TIMESTAMP(n)), and PERIOD(TIMESTAMP(n) WITH TIME ZONE) types that differ in fractional seconds precision are not distinct. For example, PERIOD(TIME(2)) and PERIOD(TIME(6)) are not distinct. |