User definded functions

User-defined function properties:

• The field “Schema name” contains the name of the schema in which the function will be located.

• The field “Function name” contains the name of the user function in the database.

• The field “Return value data type” contains the data type of the value returned by the function according to:

  • PostgreSQL Data types;

  • “meta. file” - structured file storage in the database;

  • “meta. file[]" - an array of structured file stores in the database;

  • trigger, event_trigger - for more information, see 42.9. PostgreSQL trigger procedures;

  • “string variable” - an indication of the entity whose type will be used as the returned one. For more information, see [42.3.4. Tuple Types](https://postgres pro.ru/docs/postgresql/10/plpgsql-declarations#PLPGSQL-DECLARATIONS-RECORDS);

  • “record” - the type of a string variable without a specific structure. For more information, see [42.3.5. record type](https://postgres pro.ru/docs/postgresql/10/plpgsql-declarations#PLPGSQL-DECLARATIONS-RECORDS).

• The field “Function parameters” contains a list of input values of the function with an indication of the data type in accordance with:

  • PostgreSQL Data types;

  • “meta. file” - structured file storage in the database;

  • “meta. file[]" - an array of structured file stores in the database;

  • “string variable” - an indication of the entity whose type will be used as the returned one. For more information, see [42.3.4. Tuple Types](https://postgres pro.ru/docs/postgresql/10/plpgsql-declarations#PLPGSQL-DECLARATIONS-RECORDS).

• The field “Function code” contains the program code of the function in the PL/pgSQL language.

User function relationships:

• The container “Triggers” contains triggers that use this function.