Name
sinv_create_inverse — Creates inverse mapping for the mentioned functions.
Synopsis
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.