>= [greater]

All functions > COMPARISON > >= [greater]

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

Syntax

expr1 >= expr2

expr1 >= expr2

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
• On FLOAT/DOUBLE, write .N (e.g. >.2, =.4, BETWEEN.3) for N decimal places of rounded precision via DECIMAL(38, N) staging, not N significant digits. Omitting .N uses 15 decimal places (DECIMAL(38, 15))
• IN.N is the same suffix on membership
• Any NaN operand makes the comparison NULL
• Infinity, or any finite value too large for DECIMAL(38, N), falls back to a raw float compare — .N rounding is not applied on that path

Related Functions

• GREATER_THAN_OR_EQUALS()

Examples

›= — equality branch

RETURN
    -- Equal values count
    f1 := 7 >= 7,
    f2 := 9 >= 5,
    -- Less is false
    f3 := 1 >= 5
;

›= — arrays and rows

RETURN
    -- Equal counts as greater-or-equal
    f1 := ARRAY(1, 2, 3) >= ARRAY(1., 2., 3.),
    -- Longer can exceed a matching prefix
    f2 := ARRAY(1, 2, 3, 1) >= ARRAY(1, 2, 3),
    -- Field-by-field; integer/decimal may align per field
    f3 := ROW(2 AS a) >= ROW(1. AS a)
;

›= — NULL

RETURN
    -- NULL input
    f1 := NULL::BIGINT >= 0
;