GREATER_THAN_OR_EQUALS()

All functions > COMPARISON > GREATER_THAN_OR_EQUALS()

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

Signatures

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

GREATER_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 greater 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

• >= [greater]

Examples

GREATER_THAN_OR_EQUALS — functional call

SELECT
    f1 := GREATER_THAN_OR_EQUALS(7, 7), -- Equality branch
    f2 := GREATER_THAN_OR_EQUALS(1, 5) -- Strictly less is false
;

GREATER_THAN_OR_EQUALS — chained

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