Create Type command in Vertica
Hello,
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?
CREATE TYPE
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.
Synopsis
CREATE TYPE name AS
( attribute_name data_type [, ... ] )
0
Comments
Not yet.
Thanks Ben. So do you know what could be the workaround to address this?