!= [not]

All functions > COMPARISON > != [not]

Returns TRUE if the first value does not equal the second value

Syntax

expr1 != expr2

expr1 != expr2

Notes

• Both values must be of the same or compatible types
• NULL comparisons always return NULL (three-valued logic)
• For strings, performs case-sensitive comparison
• For numeric types, supports optional decimal precision
• For ARRAY and ROW, same structural rules as =
• Opposite of equals (=)

Related Functions

• NOT_EQUALS()

Examples

!= — inequality

SELECT
    f1 := 1 != 2, -- Different numbers
    f2 := 'a' != 'b', -- Different strings
    f3 := 3 != 3 -- Same value
;

!= — arrays and rows

SELECT
    f1 := ARRAY(1, 2) != ARRAY(1., 2., 3.), -- Different lengths / elements
    f2 := ARRAY(1, 2) != ARRAY(1., 2.) -- Same values under alignment
;

!= — three-valued logic

SELECT
    f1 := NULL::BIGINT != 1, -- NULL on the left
    f2 := NULL::BIGINT != NULL::BIGINT -- NULL vs NULL
;