This section provides examples of problems that may occur when developing applications that use functions and/or operators, and describes how to deal with them.
The following error will occur when executing an SQL statement that does not abide by the general rules for functions:
ERROR: Function ****** does not exist
Note: "*****" denotes the function for which the error occurred, and the data type of its arguments.
The cause of the error will be one of the following:
The specified function does not exist.
The wrong number of arguments or wrong argument data type was specified
Check the following points and correct any errors:
Check if there are any errors in the specified function name, number of arguments, or argument data type, and revise accordingly.
Check the argument data type of the function displayed in the message. If an unintended data type is displayed, use a function such as CAST to convert it.
The following error will occur when executing an SQL statement that specifies a data type in the operator that cannot be compared:
ERROR: Operator does not exist: *****
Note: "*****" denotes the operator for which the error occurred, and the data type of the specified value.
Ensure the data type of the expressions specified on the left and right sides of the operator can be compared. If required, revise to ensure these data types can be compared by using a function such as CAST to explicitly convert them.
