Data Type Mappings

Functions are not supported for operations on the following data types, which are mapped but not verified by TDV: CID, CIDR, INET, LINE, LSEG, MACADDR, PATH, POINT, POLYGON. For example, POINT should have a format like number,number. If a value with another format is inserted, an exception is thrown.

In some circumstances, Greenplum performs type promotion that causes results to differ between push and no-push query execution. For example, with arithmetic operators a FLOAT4 column is converted to a FLOAT8/DOUBLE data type, and the Greenplum results have extra digits in the mantissa.

Greenplum Data Type	TDV Data Type
BIGINT	BIGINT
BIGSERIAL	BIGINT
BIT	CHAR
BOOL	BOOLEAN (See Mapping of Native to TDV Data Types Across TDV Versions.)
BOOLEAN	BOOLEAN (See Mapping of Native to TDV Data Types Across TDV Versions.)
BOX	VARCHAR
BYTEA	BLOB
CHAR	CHAR
CHARACTER	CHAR
CHARACTER VARYING	VARCHAR
CID	CHAR
CIDR	VARCHAR
CIRCLE	VARCHAR
DATE	DATE
DECIMAL	DECIMAL
DOUBLE PRECISION	DOUBLE
FLOAT4	FLOAT
FLOAT8	DOUBLE
INET	VARCHAR
INT2	SMALLINT
INT4	INTEGER
INT8	BIGINT
INTEGER	INTEGER
INTERVAL	VARCHAR
LINE	VARCHAR
LSEG	VARCHAR
MACADDR	VARCHAR
MONEY	DECIMAL
NUMERIC	DECIMAL
OID	BLOB
PATH	VARCHAR
POINT	CHAR
POLYGON	VARCHAR
REAL	REAL
SERIAL	INTEGER
SMALLINT	SMALLINT
TEXT	CLOB
TIME	TIME
TIMESTAMP	TIMESTAMP
UUID	CHAR
VARBIT	VARCHAR
XID	INTEGER
XML	XML