云数据库 GaussDB-CREATE TYPE:语法格式

时间：2025-01-26 10:48:52

云数据库 GaussDB

语法格式

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 name;CREATE TYPE name AS ENUM    ( [ 'label' [, ... ] ] );CREATE TYPE name AS TABLE OF data_type;

上一篇：云数据库 GaussDB-CREATE TYPE:参数说明

下一篇：云数据库 GaussDB-CREATE TYPE:功能描述