Create Type command in Vertica
I have a question. I am trying to migrate some functions from a different database to vertica. In the function they use composite data type as argument or return type. Is there any equivalent command in Vertica to this?
The CREATE TYPE command is supported only to create composite data types that may be used as the argument
or return type of user-defined PL/pgSQL or SQL language functions. Using the CREATE TYPE command
avoids the need to create a table when all that is wanted is to define a type. The composite type is specified by
a list of attribute (column) names and data types.
CREATE TYPE name AS
( attribute_name data_type [, ... ] )