EQUALS

All functions > COMPARISON > EQUALS

Returns TRUE if the first value equals the second value

Signatures

Returns: TRUE if expr1 = expr2, FALSE otherwise, NULL if either value is NULL

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 exact match
• For numeric types, supports optional decimal precision
• For dates/timestamps, compares exact date and time values

See also

• Operators