Vertica documentation is moving! Use our new documentation site at https://docs.rocketsoftware.com/bundle/vertica_24.1/page/index.html

Vertica::ColumnTypes Class Reference

Represents (unsized) types of the columns used as input/output of a User Defined Function/Transform Function.

Collaboration diagram for Vertica::ColumnTypes:

Public Member Functions
void addAny ()
Indicates that function can take any number and type of arguments.
ColumnTypes & addArrayType (Oid elementOid)
Adds a column of 1D array type.
ColumnTypes & addArrayType (const ColumnTypes &elementprototype)
Adds a column of complex array type.
ColumnTypes & addBinary ()
Adds a column of type BINARY.
ColumnTypes & addBool ()
Adds a column of type BOOLEAN.
ColumnTypes & addChar ()
Adds a column of type CHAR.
ColumnTypes & addDate ()
Adds a column of type DATE.
ColumnTypes & addFloat ()
Adds a column of type FLOAT.
ColumnTypes & addInt ()
Adds a column of type INTEGER.
ColumnTypes & addInterval ()
Adds a column of type INTERVAL/INTERVAL DAY TO SECOND.
ColumnTypes & addIntervalYM ()
Adds a column of type INTERVAL YEAR TO MONTH.
ColumnTypes & addLongVarbinary ()
Adds a column of type VARBINARY.
ColumnTypes & addLongVarchar ()
Adds a column of type VARBINARY.
ColumnTypes & addNumeric ()
Adds a column of type NUMERIC.
ColumnTypes & addRowType (const ColumnTypes &rowprototype)
Adds a column of complex row type.
ColumnTypes & addTime ()
Adds a column of type TIME.
ColumnTypes & addTimestamp ()
Adds a column of type TIMESTAMP.
ColumnTypes & addTimestampTz ()
Adds a column of type TIMESTAMP WITH TIMEZONE.
ColumnTypes & addTimeTz ()
Adds a column of type TIME WITH TIMEZONE.
ColumnTypes & addType (Oid typeOid, const ColumnTypes &complexFields=ColumnTypes())
ColumnTypes & addUserDefinedType (const char *typeName)
Adds a column of user-defined type.
ColumnTypes & addUuid ()
Adds a column of type UUID.
ColumnTypes & addVarbinary ()
Adds a column of type VARBINARY.
ColumnTypes & addVarchar ()
Adds a column of type VARCHAR.
template
strtype toString () const

Detailed Description

Represents (unsized) types of the columns used as input/output of a User Defined Function/Transform Function.

This class is used only for generating the function or transform function prototype, where the sizes and/or precisions of the data types are not known.

Member Function Documentation

◆addArrayType() [1/2]

ColumnTypes& Vertica::ColumnTypes::addArrayType(Oid elementOid)

inline Adds a column of 1D array type.

Parameters

  • elementOid: the type of the array element

Returns this

Referenced by addArrayType().

◆addArrayType() [2/2]

ColumnTypes& Vertica::ColumnTypes::addArrayType(const ColumnTypes & elementprototype)

inline Adds a column of complex array type.

Parameters

  • rowprototype: the fields of the complex array element

Returns this

◆addBinary()

ColumnTypes& Vertica::ColumnTypes::addBinary()

inline Adds a column of type BINARY.

Returns this

◆addBool()

ColumnTypes& Vertica::ColumnTypes::addBool()

inline Adds a column of type BOOLEAN.

Returns this

◆addChar()

ColumnTypes& Vertica::ColumnTypes::addChar()

inline Adds a column of type CHAR.

Returns this

◆addDate()

ColumnTypes& Vertica::ColumnTypes::addDate()

inline Adds a column of type DATE.

Returns this

◆addFloat()

ColumnTypes& Vertica::ColumnTypes::addFloat()

inline Adds a column of type FLOAT.

Returns this

◆addInt()

ColumnTypes& Vertica::ColumnTypes::addInt()

inline Adds a column of type INTEGER.

Returns this

◆addInterval()

ColumnTypes& Vertica::ColumnTypes::addInterval()

inline Adds a column of type INTERVAL/INTERVAL DAY TO SECOND.

Returns this

◆addIntervalYM()

ColumnTypes& Vertica::ColumnTypes::addIntervalYM()

inline Adds a column of type INTERVAL YEAR TO MONTH.

Returns this

◆addLongVarbinary()

ColumnTypes& Vertica::ColumnTypes::addLongVarbinary()

inline Adds a column of type VARBINARY.

Returns this

◆addLongVarchar()

ColumnTypes& Vertica::ColumnTypes::addLongVarchar()

inline Adds a column of type VARBINARY.

Returns this

◆addNumeric()

ColumnTypes& Vertica::ColumnTypes::addNumeric()

inline Adds a column of type NUMERIC.

Returns this

◆addRowType()

ColumnTypes& Vertica::ColumnTypes::addRowType(const ColumnTypes & rowprototype)

inline Adds a column of complex row type.

Parameters

  • rowprototype: the fields of the complex row type

Returns this

◆addTime()

ColumnTypes& Vertica::ColumnTypes::addTime()

inline Adds a column of type TIME.

Returns this

◆addTimestamp()

ColumnTypes& Vertica::ColumnTypes::addTimestamp()

inline Adds a column of type TIMESTAMP.

Returns this

◆addTimestampTz()

ColumnTypes& Vertica::ColumnTypes::addTimestampTz()

inline Adds a column of type TIMESTAMP WITH TIMEZONE.

Returns this

◆addTimeTz()

ColumnTypes& Vertica::ColumnTypes::addTimeTz()

inline Adds a column of type TIME WITH TIMEZONE.

Returns this

◆addType()

ColumnTypes& Vertica::ColumnTypes::addType(Oid typeOid, const ColumnTypes & complexFields = ColumnTypes())

inline Add a generic column to the prototype. Complex type fields are allowed only for complex types.

Returns this

◆addUserDefinedType()

ColumnTypes& Vertica::ColumnTypes::addUserDefinedType(const char * typeName)

inline Adds a column of user-defined type.

Returns this

◆addUuid()

ColumnTypes& Vertica::ColumnTypes::addUuid()

inline Adds a column of type UUID.

Returns this

◆addVarbinary()

ColumnTypes& Vertica::ColumnTypes::addVarbinary()

inline Adds a column of type VARBINARY.

Returns this

◆addVarchar()

ColumnTypes& Vertica::ColumnTypes::addVarchar()

inline Adds a column of type VARCHAR.

Returns this