Procedural SQL Reference
This section contains topics about SingleStore Procedural SQL (PSQL), which encompasses stored procedures, user-defined scalar-value functions (UDFs), user-defined table-valued functions (TVFs), and user-defined aggregate functions (UDAFs).
In this section
- Anonymous Code Blocks
- Control Flow Statements
- Exceptions and Exception Handling
- MySQL Client Delimiters
- Transactions in Stored Procedures
- CREATE AGGREGATE
- CREATE [OR REPLACE] EXTERNAL FUNCTION
- CREATE FUNCTION (UDF)
- CREATE FUNCTION (TVF)
- CREATE PROCEDURE
- CREATE [OR REPLACE] TEMPORARY PROCEDURE …
- DROP FUNCTION
- DROP PROCEDURE
- DROP AGGREGATE
- SHOW AGGREGATES
- SHOW CREATE FUNCTION
- SHOW CREATE AGGREGATE
- SHOW FUNCTIONS
- SHOW PROCEDURES
- ARRAY
- CALL
- CREATE_ARRAY
- COLLECT
- ECHO
- ECHO SELECT
- EXECUTE IMMEDIATE
- INSERT_ALL
- RECORD
- ROW
- QUERY
- SCALAR
- TO_QUERY
Last modified: June 5, 2023