InterBase - статьи


Функции - часть 2


Здесь же, наоборот, получаем информацию только о входных аргументах функций.

SELECT RDB$FUNCTIONS.RDB$FUNCTION_NAME, RDB$FUNCTIONS.RDB$DESCRIPTION, RDB$FUNCTIONS.RDB$MODULE_NAME, RDB$FUNCTIONS.RDB$ENTRYPOINT, RDB$FUNCTIONS.RDB$RETURN_ARGUMENT, RDB$FUNCTION_ARGUMENTS.RDB$ARGUMENT_POSITION, RDB$FUNCTION_ARGUMENTS.RDB$MECHANISM, RDB$FUNCTION_ARGUMENTS.RDB$FIELD_TYPE, RDB$TYPES.RDB$TYPE_NAME, RDB$FUNCTION_ARGUMENTS.RDB$FIELD_LENGTH, RDB$FUNCTION_ARGUMENTS.RDB$FIELD_PRECISION FROM RDB$FUNCTIONS INNER JOIN RDB$FUNCTION_ARGUMENTS ON (RDB$FUNCTIONS.RDB$FUNCTION_NAME = RDB$FUNCTION_ARGUMENTS.RDB$FUNCTION_NAME) INNER JOIN RDB$TYPES ON (RDB$FUNCTION_ARGUMENTS.RDB$FIELD_TYPE = RDB$TYPES.RDB$TYPE) WHERE ( ((RDB$FUNCTIONS.RDB$SYSTEM_FLAG = 0) or (RDB$FUNCTIONS.RDB$SYSTEM_FLAG IS NULL)) and (RDB$TYPES.RDB$FIELD_NAME = 'RDB$FIELD_TYPE') and (RDB$FUNCTIONS.RDB$RETURN_ARGUMENT <> RDB$FUNCTION_ARGUMENTS.RDB$ARGUMENT_POSITION) ) ORDER BY RDB$FUNCTIONS.RDB$FUNCTION_NAME, RDB$FUNCTION_ARGUMENTS.RDB$ARGUMENT_POSITION;




- Начало -  - Назад -  - Вперед -