Domains
You can use domains anywhere corresponding base type can be used:
- Create a column of domain type
- Read/write values from/to domain column
- Call functions with values of domain column
- etc.
- Explicit column type name in or
DESCRIBE TABLE
- Input from human-friendly format with
- Loading data from external source in human-friendly format:
Limitations
- Can’t convert index column of base type to domain type via
ALTER TABLE
. - Can’t implicitly convert string values into domain values when inserting data from another column or table.
- Domain adds no constrains on stored values.