6. Defining Function Instances : Sorting of the Function Instance Definition Array
 
Share this page                  
Sorting of the Function Instance Definition Array
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:
1. 'not equal' function instances
2. 'less than' function instances
3. 'less than/equal to' function instances
4. 'equal' function instances
5. 'greater than' function instances
6. 'greater than/equal to' function instances