Two data types are only supported in SingleStore Procedural SQL (PSQL) scalar-valued functions and stored procedures: ARRAY
and RECORD
. The QUERY
data type is only supported in stored procedures. For more information about these types, see the ARRAY, RECORD, and QUERY topics.