Example: Character Partitioning Defined Using RANGE_N Functions - Teradata Vantage

This example creates a partitioned primary index based on character data specified for a RANGE_N function. No EACH clause is specified for the RANGE_N partitioning expression in level 1 of the multilevel partitioning.

CREATE TABLE t1 (
  i INTEGER,
  j CHARACTER(4),
  k INTEGER
) PRIMARY INDEX (i)
    PARTITION BY (
      RANGE_N (
        j BETWEEN 'aaaa','cccc','eeee', 'gggg',
          'iiii','kkkk', 'mmmm','oooo','qqqq', 'ssss' 
             AND 'tttt',
        NO RANGE
      ),
      RANGE_N (
        k BETWEEN 1 AND 10 
        EACH 1
      )
);