Firebird 2.5 Language ReferenceFirebird 2.5 Language ReferenceSystem Tables → RDB$FUNCTIONS
Firebird Firebird Prev: RDB$FORMATSFirebird 2.5 Language ReferenceUp: System TablesNext: RDB$FUNCTION_ARGUMENTS

RDB$FUNCTIONS

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

[Note] 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 Name Data Type Description
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

Prev: RDB$FORMATSFirebird 2.5 Language ReferenceUp: System TablesNext: RDB$FUNCTION_ARGUMENTS
Firebird 2.5 Language ReferenceFirebird 2.5 Language ReferenceSystem Tables → RDB$FUNCTIONS