Добавил:
Upload
Опубликованный материал нарушает ваши авторские права? Сообщите нам.
Вуз:
Предмет:
Файл:База данных / IS_to_STUD / Soft / 2.1.0.17798-Final / Firebird-2.1.0.17798-0_Win32 / misc / upgrade / ib_udf / ib_udf2_params
.txt 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
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
Соседние файлы в папке ib_udf