This page describes the available functions to assist with performing boolean calculations on numeric and timestamp types.

isOrdered

isOrdered(column) return a boolean indicating whether the column values are ordered in a table.

Arguments:

• column is a column name of numeric or timestamp type.

Return value:

Return value type is boolean.

Examples:

Given a table with the following contents:

SELECT isOrdered(numeric_sequence) is_num_ordered,
       isOrdered(ts) is_ts_ordered
FROM my_table

Adding an integer and timestamp rows out-of-order

SELECT isOrdered(numeric_sequence) FROM my_table