Download Creating User-Defined Routines and User-Defined Data

Registering a User-Defined Routine . . . . . . . . . . .
Setting Privileges for a Routine . . . . . . . . . . .
Creating an SPL Routine. . . . . . . . . . . . . .
Creating an External-Language Routine . . . . . . . .
Reviewing Information about User-Defined Routines . . .
Chapter 5
Extending Data Types
In This Chapter . . . . . . . . . . . . . . . . . .
Understanding the Data Type System . . . . . . . . . .
Understanding Data Types . . . . . . . . . . . . . .
Built-In Data Types . . . . . . . . . . . . . . .
Extended Data Types . . . . . . . . . . . . . . .
Extending the Data Type System . . . . . . . . . . . .
Operations . . . . . . . . . . . . . . . . . .
Casts . . . . . . . . . . . . . . . . . . . .
Operator Classes . . . . . . . . . . . . . . . .
Optimizer Information . . . . . . . . . . . . . .
Chapter 6
5-3
5-3
5-5
5-6
5-8
5-13
5-14
5-14
5-15
5-16
Extending Operators and Built-In Functions
In This Chapter . . . . . . . . . . . .
Operators and Operator Functions . . . . .
Arithmetic Operators . . . . . . . . .
Text Operators . . . . . . . . . . .
Relational Operators . . . . . . . . .
Overloading an Operator Function . . . .
Built-In Functions . . . . . . . . . . .
Built-In Functions That You Can Overload .
Built-In Functions That You Cannot Overload
Overloading a Built-In Function . . . . .
Chapter 7
4-14
4-15
4-17
4-19
4-24
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
6-3
6-4
6-4
6-5
6-5
6-7
6-7
6-7
6-8
6-9
In This Chapter . . . . . . . . . . . . . . . . . .
Understanding Casts . . . . . . . . . . . . . . . .
Built-In Casts . . . . . . . . . . . . . . . . .
User-Defined Casts . . . . . . . . . . . . . . .
Casts That You Cannot Create . . . . . . . . . . . .
7-3
7-3
7-3
7-4
7-5
Creating User-Defined Casts
Table of Contents
v