NOT_EQUALS()

All functions > COMPARISON > NOT_EQUALS()

Returns TRUE if the first value does not equal the second value

Signatures

Returns: TRUE or FALSE according to the comparison, or NULL if either operand is NULL

NOT_EQUALS(expr1: T, expr2: T, [digits: BIGINT]) → BOOLEAN

Notes

• Both values must be of the same or compatible types
• NULL comparisons always return NULL (three-valued logic)
• For strings, performs case-sensitive comparison
• For numeric types, supports optional decimal precision
• For ARRAY and ROW, same structural rules as =
• Opposite of equals (=)

Related operators

• != [not]

Examples

NOT_EQUALS — functional call

SELECT
    f1 := NOT_EQUALS(1, 2), -- `NOT_EQUALS(expr1, expr2)` matches infix `!=`
    f2 := NOT_EQUALS(3, 3) -- Same value
;

NOT_EQUALS — chained

SELECT
    f1 := (1).NOT_EQUALS(2), -- Dot form: receiver is the left-hand operand
    f2 := (3).NOT_EQUALS(3) -- Same semantics as the prefix call
;