INFORMIX
Extending Informix-Universal Server: Data Types
Chapter 5: Creating an Opaque Data Type
Home Contents Index Master Index New Book

Creating an Opaque Data Type

What Is an Opaque Data Type?
The Internal Structure
A Fixed-Length Opaque Type
A Varying-Length Opaque Type
Support Functions
Additional SQL-Invoked Routines
Built-In Functions
Operator Functions
Aggregrate Functions
End-User Routines
How Do You Create an Opaque Data Type?
Creating the Internal Structure
Final Structure Size
Memory Alignment
Parameter Passing
Writing the Support Functions
Registering the Opaque Type with the Database
Registering the Opaque Data Type
Registering Support Functions
Creating the Casts
Granting Privileges for an Opaque Data Type
Privileges on the Opaque Data Type
Privileges on the Support Functions
Creating SQL-Invoked Functions
Operating on Data
Comparing Data
Creating End-User Routines
Customizing Use of Access Methods
Using the Generic B-Tree
Indexing Spatial Data
Other Kinds of Data
Other Operations on Opaque Data Types
Accessing an Opaque Data Type
Dropping an Opaque Data Type
A Fixed-Length Opaque Type: circle
Creating the Fixed-Length Internal Structures
Writing the circle Support Functions
Registering the circle Opaque Type
Granting Privileges on the circle Data Type
Creating SQL-Invoked Functions for the circle Data Type
Providing Indexes for the circle Data Type
Using the circle Opaque Data Type
A Varying-Length Opaque Type: image
Creating the Varying-Length Internal Structure
Writing the image Support Functions
Registering the image Opaque Type
Granting Privileges on the image Data Type
Creating SQL-Invoked Functions for the image Data Type
Providing Indexes for the image Data Type
Using the image Opaque Type



Extending Informix-Universal Server: Data Types, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.