Skip to main content

Overview of operators

Operators are generally used to connect operands or parameters and return results. Syntactically, operators can appear before, after, or between operands.

Common operators can be divided into unary and binary operators:

  • Unary operators

    Unary operators operate on a single operand. The common format for unary operators is as follows:

    Operator operand

  • Binary operators

    Binary operators operate on two operands. The common format for binary operators is as follows:

    operand1 operator operand2
    info
    • Other operators with special formats can accept more than two operands.
    • If an operator is provided with a NULL operand, the result is always NULL. The only exception is the character concatenation operator (||).

seekdb currently supports the following operators: