>= [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
    -- Equal values count
    f1 := 7 >= 7,
    -- Strictly greater
    f2 := 9 >= 5,
    -- Less is false
    f3 := 1 >= 5
;

>= — arrays and rows

SELECT
    -- 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

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