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);
Description
Creates inverse mapping for the mentioned functions (as described in the doc section
SQL Inverse Functions)
Parameters
_SINVM_NAME_IN –
the name of the forward function
_SINV_INVERSE –
an array of the names of the inverse functions (for each part).
_SINVM_FLAGS –
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.