BinaryOperator in sqlparser::ast

BinaryOperator in sqlparser::ast - Rust

Enum BinaryOperator

pub enum BinaryOperator {
Show 69 variants    Plus,
    Minus,
    Multiply,
    Divide,
    Modulo,
    StringConcat,
    Gt,
    Lt,
    GtEq,
    LtEq,
    Spaceship,
    Eq,
    NotEq,
    And,
    Or,
    Xor,
    BitwiseOr,
    BitwiseAnd,
    BitwiseXor,
    DuckIntegerDivide,
    MyIntegerDivide,
    Match,
    Regexp,
    Custom(String),
    PGBitwiseXor,
    PGBitwiseShiftLeft,
    PGBitwiseShiftRight,
    PGExp,
    PGOverlap,
    PGRegexMatch,
    PGRegexIMatch,
    PGRegexNotMatch,
    PGRegexNotIMatch,
    PGLikeMatch,
    PGILikeMatch,
    PGNotLikeMatch,
    PGNotILikeMatch,
    PGStartsWith,
    Arrow,
    LongArrow,
    HashArrow,
    HashLongArrow,
    AtAt,
    AtArrow,
    ArrowAt,
    HashMinus,
    AtQuestion,
    Question,
    QuestionAnd,
    QuestionPipe,
    PGCustomBinaryOperator(Vec<String>),
    Overlaps,
    DoubleHash,
    LtDashGt,
    AndLt,
    AndGt,
    LtLtPipe,
    PipeGtGt,
    AndLtPipe,
    PipeAndGt,
    LtCaret,
    GtCaret,
    QuestionHash,
    QuestionDash,
    QuestionDashPipe,
    QuestionDoublePipe,
    At,
    TildeEq,
    Assignment,
}

Expand description

Binary operators

Plus, e.g. a + b

Minus, e.g. a - b

Multiply, e.g. a * b

Divide, e.g. a / b

Modulo, e.g. a % b

String/Array Concat operator, e.g. a || b

Greater than, e.g. a > b

Less than, e.g. a < b

Greater equal, e.g. a >= b

Less equal, e.g. a <= b

Spaceship, e.g. a <=> b

Equal, e.g. a = b

Not equal, e.g. a <> b

And, e.g. a AND b

Or, e.g. a OR b

XOR, e.g. a XOR b

Bitwise or, e.g. a | b

Bitwise and, e.g. a & b

Bitwise XOR, e.g. a ^ b

Integer division operator // in DuckDB

MySQL DIV integer division

REGEXP operator, e.g. a REGEXP b (SQLite-specific)

Support for custom operators (such as Postgres custom operators)

Bitwise XOR, e.g. a # b (PostgreSQL-specific)

Bitwise shift left, e.g. a << b (PostgreSQL-specific)

Bitwise shift right, e.g. a >> b (PostgreSQL-specific)

Exponent, e.g. a ^ b (PostgreSQL-specific)

Overlap operator, e.g. a && b (PostgreSQL-specific)

String matches regular expression (case sensitively), e.g. a ~ b (PostgreSQL-specific)

String matches regular expression (case insensitively), e.g. a ~* b (PostgreSQL-specific)

String does not match regular expression (case sensitively), e.g. a !~ b (PostgreSQL-specific)

String does not match regular expression (case insensitively), e.g. a !~* b (PostgreSQL-specific)

String matches pattern (case sensitively), e.g. a ~~ b (PostgreSQL-specific)

String matches pattern (case insensitively), e.g. a ~~* b (PostgreSQL-specific)

String does not match pattern (case sensitively), e.g. a !~~ b (PostgreSQL-specific)

String does not match pattern (case insensitively), e.g. a !~~* b (PostgreSQL-specific)

String “starts with”, eg: a ^@ b (PostgreSQL-specific)

PostgreSQL-specific custom operator.

See CREATE OPERATOR for more information.