Built-in Operator Call
AttentionThis page documents an earlier version. Go to the latest (v2.1)version.
An expression with operators is a compound expression that combines multiple expressions using builtin operators. The following sections discuss the supported operators in Yugabyte.
||predicate for existence of a row|
NOT EXISTScan only be used in the
||Logical (boolean) negation|
+can only be used with constant expressions such as
||Logical (boolean) expression|
||Addition, append, or prepend|
||Subtraction or removal|
||Multiplication. Not yet supported|
||Division. Not yet supported|
||Not yet supported comparison expression.|
column_name = 7.
NULLwith others always yields a
IS NULLmust be used when comparing with
-are applied to a NULL argument of
COUNTERdata type, the NULL expression is replaced with a zero value before the computation. When these operators are applied to a NULL expression of all other numeric data types, the computed value is always NULL.
+either prepends or appends a value to a LIST while operator
-removes elements from LIST.
+inserts new distinct elements to a MAP or SET while operator
-removes elements from them.