Procedural Extensions

SingleStore 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)

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