Boolean functions

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:

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

is_num_ordered	is_ts_ordered
true	true

Adding an integer and timestamp rows out-of-order

SELECT isOrdered(numeric_sequence) FROM my_table

is_num_ordered	is_ts_ordered
false	false