AI agents/LLMs: Fetch /llms.txt first to access the documentation index. Remove the trailing slash and append .md to any URL to access lighter, easier-to-parse Markdown pages instead of HTML (this page is accessible at https://docs.singlestore.com/db/v8.9/reference/sql-reference/data-types/singlestore-procedural-sql-psql-types.md).
SingleStore Procedural SQL (PSQL) Types
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.