Skip to main content

Functions, arguments, types

The functions and procedures are collected in the tables below. It provides an roadmap to check availability of operations supported.

SYS.FUNCTIONS
name type references description
"id" INTEGER   The internal identifier for the function.
"name" VARCHAR   The SQL name.
"func" VARCHAR   MAL function identifier.
"mod" VARCHAR   MAL function module identifier.
"sql" BOOLEAN   The SQL statement.
"type" INTEGER   Procedure, function, aggregate, filter object.
"side_effect" BOOLEAN   It does (not) lead to updates.
"schema_id" INTEGER sys.schemas.id The schema identifier.
SYS.ARGS
name type references description
"id" INTEGER   The internal identifier for function argument.
"func_id" INTEGER sys.functions.id The corresponding function.
"name" VARCHAR   The SQL name.
"type" VARCHAR   The SQL type name.
"type_digits" INTEGER   The number of digits for number types.
"type_scale" INTEGER   The precision after decimal point.
"number" INTEGER   The position in the underlying relation.
SYS.TYPES
name type references description
"id" INTEGER   The internal identifier for the type.
"systemname" VARCHAR   MAL type name.
"sqlname" VARCHAR   SQL type name.
"digits" INTEGER   The number of digits for number types.
"scale" INTEGER   The precision after decimal point.
"radix" INTEGER   Radix for the number of digits value: 2 (= binary) or 10 (= decimal).
"eclass" INTEGER   The internal storage class equivalence identifier.
"schema_id" INTEGER sys.schemas.id The corresponding schema.