For the DBMS Server to merge the new function instance definitions with existing function instance definitions, the array of function instance definitions that you create must be specified in sorted order.

The array must be sorted by the number value of the fid_optype field. All comparisons (fid_optype = II_COMPARISON) must be first, followed by all operators (fid_optype = II_OPERATOR), normal functions (fid_type = II_NORMAL), and finally, the coercion functions (fid_optype = II_COERCION).

In each operator type, sort the function instances by the numeric value of the fid_opid field. For example, with the operator type II_COMPARISON, the function instances are sorted in the following order: