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.