Comparison

Syntax

Version 1:

value_1 = value_2

Version 2:

value_1 != value_2

Version 3:

value_1 < value_2

Version 4:

value_1 <= value_2

Version 5:

value_1 > value_2

Version 6:

value_1 => value_2

Description

Compares the value value_1 with the value value_2.

Argument types:

• value_1 — Boolean | Date | Datetime | Fractional number | Geopoint | Geopolygon | Integer | String | UUID
• value_2 — Boolean | Date | Datetime | Fractional number | Geopoint | Geopolygon | Integer | String | UUID

Return type: Boolean

Examples

1 = 1 = TRUE

7 > 2 > 1 = TRUE

Data source support

Materialized Dataset, ClickHouse 1.1, Yandex.Metrica, Microsoft SQL Server 2017 (14.0), MySQL 5.6, Oracle Database 12c (12.1), PostgreSQL 9.3.