# Data types in the pivot table

The pivot table makes use of the set data types Column Selector and Order Specifier.

These set data types are defined:

- Column Selector
- The column selector is a comma-separated list of positive integers numbering 0 for the first column and n-1 for the last column in a table of n columns.
- Order Specifier
- The order specifier is a comma-separated list of positive integers numbering 0 for the first column and n-1 for the last column in a table of n columns. Positive values specify ascending, negative values descending order.

There is a difference between not setting a value and specifying an empty value. The empty value always means the empty set. Not setting a value may mean selecting all or nothing, depending on the context.