数据仓库服务 GaussDB(DWS)-CREATE TYPE:语法格式

时间：2025-02-12 15:04:42

语法格式

  
       CREATE TYPE name AS    ( [ attribute_name data_type [ COLLATE collation ] [, ... ] ] )CREATE TYPE name (    INPUT = input_function,    OUTPUT = output_function    [ , RECEIVE = receive_function ]    [ , SEND = send_function ]    [ , TYPMOD_IN = type_modifier_input_function ]    [ , TYPMOD_OUT = type_modifier_output_function ]    [ , ANALYZE = analyze_function ]    [ , INTERNALLENGTH = { internallength | VARIABLE } ]    [ , PASSEDBYVALUE ]    [ , ALIGNMENT = alignment ]    [ , STORAGE = storage ]    [ , LIKE = like_type ]    [ , CATEGORY = category ]    [ , PREFERRED = preferred ]    [ , DEFAULT = default ]    [ , ELEMENT = element ]    [ , DELIMITER = delimiter ]    [ , COLLATABLE = collatable ])CREATE TYPE nameCREATE TYPE name AS ENUM    ( [ 'label' [, ... ] ] )