Field Definition

Use the Field Definition clause to define a new field in a named ROW type.

Field Definition:
 
|--field--data_type--+----------+-------------------------------|
                     '-NOT NULL-'

Element	Description	Restrictions	Syntax
data_type	Data type of the field	See Restrictions on Serial and Simple-Large-Object Data Types.	Identifier
field	Name of a field in row_type	Must be unique among field names of this ROW type and of its supertype	Identifier

The NOT NULL constraint on the named ROW type field applies to the corresponding columns when a typed table of the named ROW type is created.