sinv_create_inverse — Creates inverse mapping for the mentioned functions.


sinv_create_inverse ( in _SINVM_NAME_IN varchar ,
in _SINV_INVERSE any ,
in _SINVM_FLAGS integer );


Creates inverse mapping for the mentioned functions (as described in the doc section SQL Inverse Functions )



the name of the forward function


an array of the names of the inverse functions (for each part).


bit mask with:

[bit 0 - 1 if x > y <-> f(x) > f (y)) This is true of unit conversions in general but not true of hash functions or arbitrary id mappings. If the bit is set the function call may be optimized away if both operands of a comparison are calls to this function. If this is not set, the function calls may only be removed in the case of equality.