Procedural Extensions

SingleStoreDB Cloud Procedural Extensions (PSQL) are available beginning in MemSQL version 6.0. These extensions provide familiar mechanisms for SQL developers and database administrators to encapsulate custom programmatic logic, namely:

• Stored Procedures (SPs)

• User-Defined Scalar-Valued Functions (UDFs)

• User-Defined Table-Valued Functions (TVFs)

• User-Defined Aggregate Functions (UDAFs)

• External Functions

Within stored procedures, you can write flexible queries that use static parameterized SQL and dynamic SQL.