>= [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
• Supports optional decimal precision for numeric comparisons

Related Functions

• GREATER_THAN_OR_EQUALS()

Examples

>= — equality branch

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

>= — arrays and rows

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

>= — NULL

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