CUBRID Manual EN 8.3.0 - Data Type Available for Partitioning Expression

Versions available for this page: CUBRID 8.3.0 |

Introduction to CUBRID Manual » CUBRID SQL Guide » Partitioning » Partitioning Management » Data Type Available for Partitioning Expression

The following table shows data types of the column that can or cannot be used as a partition key.

Data Types Available	Data Types Unavailable
CHAR VARCHAR NCHAR VARNCHAR INTEGER SMALLINT DATE TIME TIMESTAMP	FLOAT REAL DOUBLE BIT BIT VARYING NUMERIC OR DECIMAL MONETARY SET LIST OR SEQUENCE MULTISET OBJECT

The following operator functions can be used in partition expressions to be applied to partition keys.

Number Operations
+, -, *, /, MOD, STRCAT, FLOOR, CEIL, POWER, ROUND, ABS, TRUNC
String Operations
POSITION, SUBSTRING, OCTEC_LENGTH, BIT_LENGTH, CHAR_LENGTH, LOWER, UPPER, TRIM, LTRIM, RTRIM, LPAD, RPAD, REPLACE, TRANSLATE
Date Operations
ADD_MONTH, LAST_DAY, MONTH_BETWEEN, SYS_DATE, SYS_TIME, SYS_TIMESTAMP, TO_DATE, TO_NUMBER, TO_TIME, TO_TIMESTAMP, TO_CHAR
Others
EXTRACT, CAST

Previous document: Partition Pruning