Create Type command in Vertica

he437580he437580 Registered User

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 [, ... ] )

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file