Tutorial exercise 3: Creating row data types

This exercise demonstrates how to create row data types and user-defined routines that operate on them. This exercise consists of 11 steps. It takes approximately one hour to complete.

The example RowCircle DataBlade module creates two new data types, rciPoint and rciCircle, and two new functions, rciDistance() and rciContains().

The RowCircle DataBlade module enables you to:

• Store circles or points in a single column of a database table.
• Calculate the distance between two points.
• Calculate whether a circle contains a point.

The following diagram illustrates the type of data RowCircle data types contain.

Figure 1. Type of data that RowCircle data types contain