> [greater]

All functions > COMPARISON > > [greater]

Returns TRUE if the first value is strictly greater than the second value

Syntax

expr1 > expr2

expr1 > expr2

Notes

• Both values must be of comparable types
• NULL comparisons always return NULL (three-valued logic)
• For strings, uses lexicographic (dictionary) ordering
• For dates/timestamps, later dates are "greater than" earlier dates
• 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 digits of rounded precision via DECIMAL(38, N) staging
• 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()

Examples

› — typical comparisons

SELECT
    -- Numeric
    f1 := 5 > 3,
    -- Strings
    f2 := 'zebra' > 'apple'
;

› — arrays and rows

SELECT
    -- Lexicographic; longer can exceed when the prefix is equal
    f1 := ARRAY(1, 2, 3, 1) > ARRAY(1, 2, 3),
    -- Lexicographic; first difference decides
    f2 := ARRAY(1, 2, 3) > ARRAY(1., 2., 4.),
    -- Row field-by-field; integer/decimal may align per field
    f3 := ROW(2 AS a) > ROW(1. AS a)
;

› — three-valued logic

SELECT
    -- NULL compared to value
    f1 := NULL::BIGINT > 0
;