<= [less]

All functions > COMPARISON > <= [less]

Returns TRUE if the first value is less 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 less 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 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

• LESS_THAN_OR_EQUALS()

Examples

‹= — equality branch

SELECT
    -- Equal values count
    f1 := 3 <= 3,
    -- Strictly less
    f2 := 2 <= 3,
    -- Greater is false
    f3 := 4 <= 3
;

‹= — arrays and rows

SELECT
    -- Equal as lexicographic values
    f1 := ARRAY(1, 2, 3) <= ARRAY(1., 2., 3.),
    -- Shorter is less when the shared prefix is equal
    f2 := ARRAY(1, 2) <= ARRAY(1., 2., 3.),
    -- Field-wise; integer/decimal may align
    f3 := ROW(1 AS a) <= ROW(1. AS a)
;

‹= — NULL

SELECT
    -- NULL input
    f1 := NULL::BIGINT <= 1
;