Skip to main content

PQL47 (PQL Function Library - CPM 4.7)

Comparison operators

Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7

Description

The comparison operators: = (equal), != (not equal), < (less than), (less than or equal), >(greater than) and (greater than or equal) can be used to formulate conditions.

They are all binary operators, meaning they must be used with both a left-hand side and a right-hand side argument.

Supported types

The operators can be applied to any data type, with the following limitations:

  • DATE column: Can only be compared to another DATE column or a DATE constant.

  • FLOAT column: Can be compared to a column or a constant of either type FLOAT or INT.

  • INT column: Can be compared to a column or a constant of either type FLOAT or INT.

  • STRING column: Can only be compared to another STRING column or a STRING constant.

Usage

Comparison operators can be used in the following contexts:

NULL handling

If one of the input values is NULL, the comparison operator will return false since the condition cannot be fulfilled.

The order of precedence for comparison operators is described in the functions and operators section.

See also: