information_schema.routines.data_type

mysql

type: LONGTEXT NULL
8
type: VARCHAR NOT NULL
5.7

mariadb

type: NULL
Note:
The column's data type.
© 2022 MariaDB
5.1-10.8
type: VARCHAR NOT NULL
Note:
The column's data type.
© 2022 MariaDB
10.2-10.7

tidb

postgres

type: CHARACTER_DATA NULL
Note:
Return data type of the function, if it is a built-in type, or ARRAY if it is some array (in that case, see the view element_types), else USER-DEFINED (in that case, the type is identified in type_udt_name and associated columns). Null for a procedure.
© 1996-2022 The PostgreSQL Global Development Group
11-15
Note:
Return data type of the function, if it is a built-in type, or ARRAY if it is some array (in that case, see the view element_types), else USER-DEFINED (in that case, the type is identified in type_udt_name and associated columns).
© 1996-2022 The PostgreSQL Global Development Group
10
type: CHARACTER_DATA
Note:
Return data type of the function, if it is a built-in type, or ARRAY if it is some array (in that case, see the view element_types), else USER-DEFINED (in that case, the type is identified in type_udt_name and associated columns).
© 1996-2022 The PostgreSQL Global Development Group
7.4-9.6

cockroachdb

type: NULL
Note:
Always NULL.
© 2022 CockroachDB
20.1-21.1

mssql

type: NVARCHAR(128) NULL
Note:
Data type of the return value of the function. Returns table if a table-valued function.
© Microsoft 2022
aps-pdw-2016-sql-server-ver15