Equal to | EQUAL

Syntax

EQUAL( [input], [other] )

Parameters

input
Any data may be used as the input.

other
Any data may be used as the other.

Return Value

TRUE if the VALUE is equal to the OTHER. FALSE, otherwise.

Description

Determine if a value is equal to another. Comparison is done structurally without any type cooercion. If values of different types are provided, the comparison is done by type with the following precedence (from lowest to highest):

1. UNDEFINED
2. NULL
3. BOOLEAN
4. NUMBER
5. STRING
6. DATE
7. ARRAY / LIST
8. OBJECT / MAP

UNDEFINED values are always considered equal. NULL values are also always considered equal. FALSE is less than TRUE. NUMBER values are compared as one would expect. STRING values are compared alphanumerically. DATE values are compared normally. ARRAY values are compared item by item where the first non-equal value is the result. MAP value are currently always considered equal, but this is likely to change in a future update, and should not be relied upon.

Examples

EQUAL(1, 2) # returns FALSE

EQUAL(2, 1) # returns FALSE

EQUAL(1, 1) # returns TRUE

EQUAL("abc", "abd") # returns FALSE

EQUAL([1, 2, 3], [1, 2, 3]) # returns TRUE

EQUAL([1, 2, 3], [1, 2, 4]) # returns FALSE

EQUAL([1, 2, 3], [1, 2]) # returns FALSE

EQUAL([1, 2, 3], [1, 3]) # returns FALSE

EQUAL(null, null) # returns TRUE