Exercise 5: Creating Opaque Data Types, continued

DataBlade Developers Kit Tutorial

InfoShelf Home

List of Exercises

Add the Distance() routine.

Choose Edit Insert Routine and enter the following information in the New Routine wizard.


Routine Property	Value
Routine Name (SQL)	Distance
Return type	double precision
Statement Local Variable	No
Arguments	1. Name: Pnt1, Type: Pnt, Default: none 2. Name: Pnt2, Type: Pnt, Default: none
Language	C
Options for how the database server calls this routine (page 5)	Only the Routine does not accept NULL arguments check box should be checked; uncheck the Routine may return inconsistent check box.
Routine Name (C)	Distance
Shared object path	Leave as default
Behavior of routines	Well-behaved
Special stack requirements	None
Cost	0
Related routines	None
Grant execute privileges	Grant execute privileges

Click Finish and then choose Project Save to save your project.

Add the Contains() routine.

Choose Edit Insert Routine and enter the following information in the New Routine wizard.


Routine Property	Value
Routine Name (SQL)	Contains
Return type	Boolean
Statement Local Variable	No
Arguments	1. Name: Circ1, Type: Circ, Default: none 2. Name: Pnt1, Type: Pnt, Default: none
Language	C
Options for how the database server calls this routine (page 5)	Only the Routine does not accept NULL arguments check box should be checked; uncheck the Routine may return inconsistent check box.
Routine Name (C)	Contains
Shared object path	Leave as default
Behavior of routines	Well-behaved
Special stack requirements	None
Cost	0
Related routines	None
Grant execute privileges	Grant execute privileges

Click Finish and then choose Project Save to save your project.