Comparison operators (=, >, <, ...)

Comparison operators create properties which return the result of the comparison operation. The values of the created properties belong to the built-in class BOOLEAN.

The platform currently supports the following comparison operators:

Operator	Name	Description	Example	Result
= or ==	Equality	Takes two operands and returns TRUE if the operands are equal	5 = 5 or 5 == 5	TRUE
!=	Inequality	Accepts two operands and returns TRUE if the operands are not equal	3 != 5	TRUE
>, <	Strict comparison	Accepts two operands and returns TRUE if the strict comparison condition is met	3 > 5	NULL
>=, <=	Non-strict comparison	Accepts two operands and returns TRUE if the non-strict comparison condition is met	4 <= 5	TRUE
LIKE	Comparison with a pattern	Accepts two operands: a string and a pattern. Returns TRUE if the string matches the pattern	'abc' LIKE 'a%'	TRUE
MATCH	Full-text search	Takes a string or TSVECTOR on the left and a string or TSQUERY on the right. For string operands it performs full-text search and an additional substring inclusion check, while prepared TSVECTOR / TSQUERY values are used directly	'abc def' MATCH 'abc'	TRUE

If one of the operands is NULL, all operators will return NULL as a result.

Language

Description of common comparison operators.
To create a property that compares a string with a pattern, use the LIKE operator. For full-text search, use the MATCH operator.

Examples

equalBarcodes = barcode(a) == barcode(b);
outOfIntervalValue1(value, left, right) = value < left OR value > right;
outOfIntervalValue2(value, left, right) = NOT (value >= left AND value <= right);
isPhoneNumber(value) = value LIKE '(___) ___-____';