Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 | 

Data Types Available for Partition Expressions

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

NCHARN

CHAR

VARYING

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 Operation Functions

+

-

*

/

MOD

STRCAT

FLOOR

CEIL

POWER

ROUND

ABS

TRUNC

String Operation Functions

POSITION

SUBSTRING

OCTEC_LENGTH

BIT_LENGTH

CHAR_LENGTH

LOWER

UPPER

TRIM

LTRIM

RTRIM

LPAD

RPAD

REPLACE

TRANSLATE

 

 

Date Operation Functions

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