Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-8.x)/ SQL Reference/ Data Types/ Data Types Supported by the Vectorized Executor
Updated on 2025-05-29 GMT+08:00

Data Types Supported by the Vectorized Executor

Table 1 lists the data types supported by the vectorized executor.

Table 1 Data types supported by the vectorized executor

Category

Data Type

Length

Supported or Not

Numeric Types

tinyint [unsigned]

1

Supported

smallint [unsigned]

2

Supported

mediumint [unsigned]

3

Supported

integer [unsigned]

4

Supported

bigint [unsigned]

8

Supported

decimal

-1

Supported

numeric

-1

Supported

real

4

Supported

double precision

8

Supported

smallserial

2

Supported

serial

4

Supported

bigserial

8

Supported

largeserial

-1

Supported

Monetary Types

money

8

Supported

Boolean Types

boolean

1

Supported

Character Types

character varying(n), varchar(n)

-1

Supported

character(n), char(n),nchar(n)

n

Supported

character, char

1

Supported

text

-1

Supported

varchar2(n)

-1

Supported

nvarchar2(n)

-1

Supported

clob

-1

Supported

Binary Types

raw

-1

Supported

bytea

-1

Supported

Bit String Types

bit(n)

n

Supported

bit varying(n)

-1

Supported

Date/Time Types

timestamp with time zone

8

Supported

timestamp without time zone

8

Supported

date

4

Supported

time without time zone

8

Supported

time with time zone

12

Supported

interval

16

Supported

Network Address Types

cidr

7 or 19

Supported

inet

7 or 19

Supported

XML Types

xml

-1

Supported

Other Types

enum

An enumerated type is a list of one or more quoted labels, each of which must be 1 to 63 bytes long.

Supported

Currently, the enumerated type can be created only in the following mode. For details, see CREATE TYPE.
CREATE TYPE name AS ENUM (['label' [, ...]]);