Sophie

Sophie

distrib > Mandriva > current > x86_64 > media > contrib-testing > by-pkgid > d3c0e693d0ab986784ec6f7bedfc9722 > files > 142

firebird-2.1.4.18393.0-2mdv2010.2.x86_64.rpm

CVC:
This is how v2's ib_udf parameters look in system tables.
Comparing this file against ib_udf_params.txt we get ib_udf_upgrade.sql
that will take us from v1's ib_udf to v2's ib_udf.

RDB$FUNCTION_NAME               RDB$ARGUMENT_POSITION RDB$MECHANISM 
=============================== ===================== ============= 

ABS                                                 0             0 
ABS                                                 1             1 
ACOS                                                0             0 
ACOS                                                1             1 
ASCII_CHAR                                          0            -1 
ASCII_CHAR                                          1             5 
ASCII_VAL                                           0             0 
ASCII_VAL                                           1             1 
ASIN                                                0             0 
ASIN                                                1             1 
ATAN                                                0             0 
ATAN                                                1             1 
ATAN2                                               0             0 
ATAN2                                               1             1 
ATAN2                                               2             1 
BIN_AND                                             0             0 
BIN_AND                                             1             1 
BIN_AND                                             2             1 
BIN_OR                                              0             0 
BIN_OR                                              1             1 

RDB$FUNCTION_NAME               RDB$ARGUMENT_POSITION RDB$MECHANISM 
=============================== ===================== ============= 
BIN_OR                                              2             1 
BIN_XOR                                             0             0 
BIN_XOR                                             1             1 
BIN_XOR                                             2             1 
CEILING                                             0             0 
CEILING                                             1             1 
COS                                                 0             0 
COS                                                 1             1 
COSH                                                0             0 
COSH                                                1             1 
COT                                                 0             0 
COT                                                 1             1 
DIV                                                 0             0 
DIV                                                 1             1 
DIV                                                 2             1 
FLOOR                                               0             0 
FLOOR                                               1             1 
LN                                                  0             0 
LN                                                  1             1 
LOG                                                 0             0 

RDB$FUNCTION_NAME               RDB$ARGUMENT_POSITION RDB$MECHANISM 
=============================== ===================== ============= 
LOG                                                 1             1 
LOG                                                 2             1 
LOG10                                               0             0 
LOG10                                               1             1 
LOWER                                               0            -1 
LOWER                                               1             5 
LPAD                                                0            -1 
LPAD                                                1             5 
LPAD                                                2             1 
LPAD                                                3             5 
LTRIM                                               0            -1 
LTRIM                                               1             5 
MOD                                                 0             0 
MOD                                                 1             1 
MOD                                                 2             1 
PI                                                  0             0 
RAND                                                0             0 
RPAD                                                0            -1 
RPAD                                                1             5 
RPAD                                                2             1 

RDB$FUNCTION_NAME               RDB$ARGUMENT_POSITION RDB$MECHANISM 
=============================== ===================== ============= 
RPAD                                                3             5 
RTRIM                                               0            -1 
RTRIM                                               1             5 
SIGN                                                0             0 
SIGN                                                1             1 
SIN                                                 0             0 
SIN                                                 1             1 
SINH                                                0             0 
SINH                                                1             1 
SQRT                                                0             0 
SQRT                                                1             1 
STRLEN                                              0             0 
STRLEN                                              1             1 
SUBSTR                                              0            -1 
SUBSTR                                              1             5 
SUBSTR                                              2             1 
SUBSTR                                              3             1 
SUBSTRLEN                                           0            -1 
SUBSTRLEN                                           1             5 
SUBSTRLEN                                           2             1 

RDB$FUNCTION_NAME               RDB$ARGUMENT_POSITION RDB$MECHANISM 
=============================== ===================== ============= 
SUBSTRLEN                                           3             1 
TAN                                                 0             0 
TAN                                                 1             1 
TANH                                                0             0 
TANH                                                1             1