Procedural SQL Reference

This section contains topics about SingleStoreProcedural SQL (PSQL), which encompasses stored procedures, user-defined scalar-value functions (UDFs), user-defined table-valued functions (TVFs), and user-defined aggregate functions (UDAFs).

• Control Flow Statements

• Exceptions and Exception Handling

• MySQL Client Delimiters

• Transactions in Stored Procedures

• CREATE FUNCTION (UDF)

• CREATE FUNCTION (TVF)

• CREATE PROCEDURE

• CREATE AGGREGATE

• DROP FUNCTION

• DROP PROCEDURE

• DROP AGGREGATE

• SHOW CREATE FUNCTION

• SHOW CREATE AGGREGATE

• SHOW FUNCTIONS

• SHOW AGGREGATES

• ARRAY

• CALL

• INSERT_ALL

• CREATE_ARRAY

• COLLECT

• ECHO

• ECHO SELECT

• EXECUTE IMMEDIATE

• RECORD

• ROW

• QUERY

• SCALAR

• TO_QUERY