Distinct data type
A distinct data type has an internal and external representation identical to another data type, but the database server treats it as a different data type. Any existing routines on the source data type are automatically registered on the distinct data type. However, you can define new routines that operate only on the distinct data type.
You can define custom support routines and user-defined routines for your distinct data type. You can also overload existing user-defined routines and built-in routines to work on your distinct type.
Property | Default value | Description |
---|---|---|
Name | prefixDistinctType | The name of the distinct type. This name must be unique. |
Source type | None | The data type the distinct type is based on. Can be any existing data type. The distinct type inherits all properties of the source type. |