Getting started
User guides
Administration guides
Reference guides
Resources
Updated Aug 04, 2022
Send us feedback
==
Returns true if expr1 equals expr2, or false otherwise.
true
expr1
expr2
false
expr1 == expr2
expr1: An expression of any comparable type.
expr2: An expression sharing a least common type with expr1.
A BOOLEAN.
This function is a synonym for = (eq sign) operator.
> SELECT 2 == 2; true > SELECT 1 == '1'; true > SELECT true == NULL; NULL > SELECT NULL == NULL; NULL
< (lt sign) operator
<= (lt eq sign) operator
> (gt sign) operator
>= (gt eq sign) operator
<=> (lt eq gt sign) operator
!= (bangeq sign) operator
== (eq eq sign) operator
<> (lt gt sign) operator
SQL data type rules