Chapter 36. Extending SQL#
Chapter 36. Extending SQL
Table of Contents
- 36.1. How Extensibility Works
- 36.2. The Tantor SE Type System
- 36.3. User-Defined Functions
- 36.4. User-Defined Procedures
- 36.5. Query Language (SQL) Functions
- 36.5.1. Arguments for SQL Functions
- 36.5.2. SQL Functions on Base Types
- 36.5.3. SQL Functions on Composite Types
- 36.5.4. SQL Functions with Output Parameters
- 36.5.5. SQL Procedures with Output Parameters
- 36.5.6. SQL Functions with Variable Numbers of Arguments
- 36.5.7. SQL Functions with Default Values for Arguments
- 36.5.8. SQL Functions as Table Sources
- 36.5.9. SQL Functions Returning Sets
- 36.5.10. SQL Functions Returning
TABLE - 36.5.11. Polymorphic SQL Functions
- 36.5.12. SQL Functions with Collations
- 36.6. Function Overloading
- 36.7. Function Volatility Categories
- 36.8. Procedural Language Functions
- 36.9. Internal Functions
- 36.10. Function Optimization Information
- 36.11. User-Defined Aggregates
- 36.12. User-Defined Types
- 36.13. User-Defined Operators
- 36.14. Operator Optimization Information
- 36.15. Interfacing Extensions to Indexes
- 36.16. Packaging Related Objects into an Extension
- 36.17. Extension Building Infrastructure
In the sections that follow, we will discuss how you can extend the Tantor SE SQL query language by adding:
functions (starting in Section 36.3)
aggregates (starting in Section 36.11)
data types (starting in Section 36.12)
operators (starting in Section 36.13)
operator classes for indexes (starting in Section 36.15)
packages of related objects (starting in Section 36.16)