Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 | 

Data Types Available for Partitioning Expression

Description

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