Enum BinaryOperator

pub enum BinaryOperator {
    Plus,
    Minus,
    Multiply,
    Divide,
    Modulo,
    StringConcat,
    Gt,
    Lt,
    GtEq,
    LtEq,
    Spaceship,
    Eq,
    NotEq,
    And,
    Or,
    Xor,
    BitwiseOr,
    BitwiseAnd,
    BitwiseXor,
    DuckIntegerDivide,
    MyIntegerDivide,
    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,
}

Binary operators

Variants

Plus

Plus, e.g. a + b

Minus

Minus, e.g. a - b

Multiply

Multiply, e.g. a * b

Divide

Divide, e.g. a / b

Modulo

Modulo, e.g. a % b

StringConcat

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

Gt

Greater than, e.g. a > b

Lt

Less than, e.g. a < b

GtEq

Greater equal, e.g. a >= b

LtEq

Less equal, e.g. a <= b

Spaceship

Spaceship, e.g. a <=> b

Eq

Equal, e.g. a = b

NotEq

Not equal, e.g. a <> b

And

And, e.g. a AND b

Or

Or, e.g. a OR b

Xor

XOR, e.g. a XOR b

BitwiseOr

Bitwise or, e.g. a | b

BitwiseAnd

Bitwise and, e.g. a & b

BitwiseXor

Bitwise XOR, e.g. a ^ b

DuckIntegerDivide

Integer division operator // in DuckDB

MyIntegerDivide

MySQL DIV integer division

Custom(String)

Support for custom operators (such as Postgres custom operators)

PGBitwiseXor

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

PGBitwiseShiftLeft

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

PGBitwiseShiftRight

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

PGExp

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

PGOverlap

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

PGRegexMatch

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

PGRegexIMatch

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

PGRegexNotMatch

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

PGRegexNotIMatch

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

PGLikeMatch

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

PGILikeMatch

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

PGNotLikeMatch

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

PGNotILikeMatch

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

PGStartsWith

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

Arrow

The -> operator.

On PostgreSQL, this operator extracts a JSON object field or array element, for example '{"a":"b"}'::json -> 'a' or [1, 2, 3]'::json -> 2.

See https://www.postgresql.org/docs/current/functions-json.html.

LongArrow

The ->> operator.

On PostgreSQL, this operator extracts a JSON object field or JSON array element and converts it to text, for example '{"a":"b"}'::json ->> 'a' or [1, 2, 3]'::json ->> 2.

See https://www.postgresql.org/docs/current/functions-json.html.

HashArrow

The #> operator.

On PostgreSQL, this operator extracts a JSON sub-object at the specified path, for example:

'{"a": {"b": ["foo","bar"]}}'::json #> '{a,b,1}'

See https://www.postgresql.org/docs/current/functions-json.html.

HashLongArrow

The #>> operator.

A PostgreSQL-specific operator that extracts JSON sub-object at the specified path, for example

'{"a": {"b": ["foo","bar"]}}'::json #>> '{a,b,1}'

See https://www.postgresql.org/docs/current/functions-json.html.

AtAt

The @@ operator.

On PostgreSQL, this is used for JSON and text searches.

See https://www.postgresql.org/docs/current/functions-json.html. See https://www.postgresql.org/docs/current/functions-textsearch.html.

AtArrow

The @> operator.

On PostgreSQL, this is used for JSON and text searches.

See https://www.postgresql.org/docs/current/functions-json.html. See https://www.postgresql.org/docs/current/functions-textsearch.html.

ArrowAt

The <@ operator.

On PostgreSQL, this is used for JSON and text searches.

See https://www.postgresql.org/docs/current/functions-json.html. See https://www.postgresql.org/docs/current/functions-textsearch.html.

HashMinus

The #- operator.

On PostgreSQL, this operator is used to delete a field or array element at a specified path.

See https://www.postgresql.org/docs/current/functions-json.html.

AtQuestion

The @? operator.

On PostgreSQL, this operator is used to check the given JSON path returns an item for the JSON value.

See https://www.postgresql.org/docs/current/functions-json.html.

Question

The ? operator.

On PostgreSQL, this operator is used to check whether a string exists as a top-level key within the JSON value

See https://www.postgresql.org/docs/current/functions-json.html.

QuestionAnd

The ?& operator.

On PostgreSQL, this operator is used to check whether all of the the indicated array members exist as top-level keys.

See https://www.postgresql.org/docs/current/functions-json.html.

QuestionPipe

The ?| operator.

On PostgreSQL, this operator is used to check whether any of the the indicated array members exist as top-level keys.

See https://www.postgresql.org/docs/current/functions-json.html.

PGCustomBinaryOperator(Vec<String>)

PostgreSQL-specific custom operator.

See CREATE OPERATOR for more information.

Overlaps

The OVERLAPS operator

Specifies a test for an overlap between two datetime periods: https://jakewheat.github.io/sql-overview/sql-2016-foundation-grammar.html#overlaps-predicate

Trait Implementations

impl Clone for BinaryOperator

fn clone(&self) -> BinaryOperator

Returns a copy of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for BinaryOperator

fn fmt(&self, f: &mut Formatter<'_>) -> Result<(), Error>

Formats the value using the given formatter.

impl Display for BinaryOperator

fn fmt(&self, f: &mut Formatter<'_>) -> Result<(), Error>

Formats the value using the given formatter.

impl Hash for BinaryOperator

fn hash<__H>(&self, state: &mut __H)

where __H: Hasher,

Feeds this value into the given Hasher.

fn hash_slice<H>(data: &[Self], state: &mut H)

where H: Hasher, Self: Sized,

Feeds a slice of this type into the given Hasher.

impl Ord for BinaryOperator

fn cmp(&self, other: &BinaryOperator) -> Ordering

This method returns an Ordering between self and other.

fn max(self, other: Self) -> Self

where Self: Sized,

Compares and returns the maximum of two values.

fn min(self, other: Self) -> Self

where Self: Sized,

Compares and returns the minimum of two values.

fn clamp(self, min: Self, max: Self) -> Self

where Self: Sized,

Restrict a value to a certain interval.

impl PartialEq for BinaryOperator

fn eq(&self, other: &BinaryOperator) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl PartialOrd for BinaryOperator

fn partial_cmp(&self, other: &BinaryOperator) -> Option<Ordering>

This method returns an ordering between self and other values if one exists.

fn lt(&self, other: &Rhs) -> bool

Tests less than (for self and other) and is used by the < operator.

fn le(&self, other: &Rhs) -> bool

Tests less than or equal to (for self and other) and is used by the <= operator.

fn gt(&self, other: &Rhs) -> bool

Tests greater than (for self and other) and is used by the > operator.

fn ge(&self, other: &Rhs) -> bool

Tests greater than or equal to (for self and other) and is used by the >= operator.

impl Visit for BinaryOperator

fn visit<V>(&self, visitor: &mut V) -> ControlFlow<<V as Visitor>::Break>

where V: Visitor,

impl VisitMut for BinaryOperator

fn visit<V>(&mut self, visitor: &mut V) -> ControlFlow<<V as VisitorMut>::Break>

where V: VisitorMut,

impl Eq for BinaryOperator

impl StructuralPartialEq for BinaryOperator