Skip to main content

Create Type command in Vertica

  • June 25, 2018
  • 2 replies
  • 12 views

he437580

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

2 replies

Ben_Vandiver
Forum|alt.badge.img
  • Participating Frequently
  • June 26, 2018

Not yet. :)


he437580
  • Author
  • New Participant
  • June 26, 2018

Thanks Ben. So do you know what could be the workaround to address this?