Type Definitions

type-definition:
   CREATE TYPE [ schema_name '.' ] type_name
      EXTERNAL NAME  MAL_type_name

drop_type:
   DROP TYPE [ schema_name '.' ] type_name
      [ RESTRICT | CASCADE ]

Declare a new user-defined data type.
The implementation (structure, operators & functions both scalar and bulk) must be specified externally in C code and MAL script.
For examples see the C implementations of data types: blob, inet, json, url, uuid and xml and SQL script code for json type.

See also the MAL Type System.

Note: This command is MonetDB specific. External implies language MAL.

Associated system table: sys.types