LESS_THAN_OR_EQUALS()

All functions > COMPARISON > LESS_THAN_OR_EQUALS()

Returns TRUE if the first value is less than or equal to the second value

Signatures

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

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

Notes

• Both values must be of comparable types
• NULL comparisons always return NULL (three-valued logic)
• Returns TRUE if values are equal OR first is less than second
• For strings, uses lexicographic (dictionary) ordering
• For dates/timestamps, compares chronologically
• For ARRAY and ROW, ordering is lexicographic / field-by-field when types align
• Supports optional decimal precision for numeric comparisons

Related operators

• <= [less]

Examples

LESS_THAN_OR_EQUALS — functional call

SELECT
    f1 := LESS_THAN_OR_EQUALS(3, 3), -- Equality branch
    f2 := LESS_THAN_OR_EQUALS(4, 3) -- Strictly greater is false
;

LESS_THAN_OR_EQUALS — chained

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