D.13. RDB$FUNCTIONS

RDB$FUNCTIONS stores the information needed by the engine about external functions (user-defined functions, UDFs).

ⓘ
Note

In future major releases (Firebird 3.0+) RDB$FUNCTIONS will also store the information about stored functions: user-defined functions written in PSQL.

Column NameData TypeDescription

RDB$FUNCTION_NAME

CHAR(31)

The unique (declared) name of the external function

RDB$FUNCTION_TYPE

SMALLINT

Not currently used

RDB$QUERY_NAME

CHAR(31)

Not currently used

RDB$DESCRIPTION

BLOB TEXT

Any text with comments related to the external function

RDB$MODULE_NAME

VARCHAR(255)

The name of the dynamic library or shared object where the code of the external function is located

RDB$ENTRYPOINT

CHAR(31)

The exported name of the external function in the function library. Note, this is often not the same as RDB$FUNCTION_NAME, which is the identifier with which the external function is declared to the database

RDB$RETURN_ARGUMENT

SMALLINT

The position number of the returned argument in the list of parameters corresponding to input arguments

RDB$SYSTEM_FLAG

SMALLINT

Flag indicating whether the filter is user-defined or internally defined:

0 - user-defined 1 - internally defined