# 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](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/array.md), [RECORD](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/record.md), and [QUERY](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/query.md) topics.

***

Modified at: September 5, 2024

Source: [/db/v9.1/reference/sql-reference/data-types/singlestore-procedural-sql-psql-types/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-types/singlestore-procedural-sql-psql-types/)

(An index of the documentation is available at /llms.txt)