Enum Operator

pub enum Operator {
    Eq,
    NotEq,
    Lt,
    LtEq,
    Gt,
    GtEq,
    Plus,
    Minus,
    Multiply,
    Divide,
    Modulo,
    And,
    Or,
    IsDistinctFrom,
    IsNotDistinctFrom,
    RegexMatch,
    RegexIMatch,
    RegexNotMatch,
    RegexNotIMatch,
    LikeMatch,
    ILikeMatch,
    NotLikeMatch,
    NotILikeMatch,
    BitwiseAnd,
    BitwiseOr,
    BitwiseXor,
    BitwiseShiftRight,
    BitwiseShiftLeft,
    StringConcat,
    AtArrow,
    ArrowAt,
    Arrow,
    LongArrow,
    HashArrow,
    HashLongArrow,
    AtAt,
    IntegerDivide,
    HashMinus,
    AtQuestion,
    Question,
    QuestionAnd,
    QuestionPipe,
}

Operators applied to expressions

Variants

Eq

Expressions are equal

NotEq

Expressions are not equal

Lt

Left side is smaller than right side

LtEq

Left side is smaller or equal to right side

Gt

Left side is greater than right side

GtEq

Left side is greater or equal to right side

Plus

Addition

Minus

Subtraction

Multiply

Multiplication operator, like *

Divide

Division operator, like /

Modulo

Remainder operator, like %

And

Logical AND, like &&

Or

Logical OR, like ||

IsDistinctFrom

IS DISTINCT FROM (see distinct)

IsNotDistinctFrom

IS NOT DISTINCT FROM (see not_distinct)

RegexMatch

Case sensitive regex match

RegexIMatch

Case insensitive regex match

RegexNotMatch

Case sensitive regex not match

RegexNotIMatch

Case insensitive regex not match

LikeMatch

Case sensitive pattern match

ILikeMatch

Case insensitive pattern match

NotLikeMatch

Case sensitive pattern not match

NotILikeMatch

Case insensitive pattern not match

BitwiseAnd

Bitwise and, like &

BitwiseOr

Bitwise or, like |

BitwiseXor

Bitwise xor, such as ^ in MySQL or # in PostgreSQL

BitwiseShiftRight

Bitwise right, like >>

BitwiseShiftLeft

Bitwise left, like <<

StringConcat

String concat

AtArrow

At arrow, like @>.

Currently only supported to be used with lists:

select [1,3] <@ [1,2,3]

ArrowAt

Arrow at, like <@.

Currently only supported to be used with lists:

select [1,2,3] @> [1,3]

Arrow

Arrow, like ->.

Not implemented in DataFusion yet.

LongArrow

Long arrow, like ->>

Not implemented in DataFusion yet.

HashArrow

Hash arrow, like #>

Not implemented in DataFusion yet.

HashLongArrow

Hash long arrow, like #>>

Not implemented in DataFusion yet.

AtAt

At at, like @@

Not implemented in DataFusion yet.

IntegerDivide

Integer division operator, like DIV from MySQL or // from DuckDB

Not implemented in DataFusion yet.

HashMinus

Hash Minis, like #-

Not implemented in DataFusion yet.

AtQuestion

At question, like @?

Not implemented in DataFusion yet.

Question

Question, like ?

Not implemented in DataFusion yet.

QuestionAnd

Question and, like ?&

Not implemented in DataFusion yet.

QuestionPipe

Question pipe, like ?|

Not implemented in DataFusion yet.

Implementations

impl Operator

pub fn negate(&self) -> Option<Operator>

If the operator can be negated, return the negated operator otherwise return None

pub fn is_numerical_operators(&self) -> bool

Return true if the operator is a numerical operator.

For example, ‘Binary(a, +, b)’ would be a numerical expression. PostgresSQL concept: https://www.postgresql.org/docs/7.0/operators2198.htm

pub fn supports_propagation(&self) -> bool

Return true if the comparison operator can be used in interval arithmetic and constraint propagation

For example, ‘Binary(a, >, b)’ expression supports propagation.

pub fn is_comparison_operator(&self) -> bool

👎Deprecated since 43.0.0: please use supports_propagation instead

Return true if the comparison operator can be used in interval arithmetic and constraint propagation

For example, ‘Binary(a, >, b)’ expression supports propagation.

pub fn is_logic_operator(&self) -> bool

Return true if the operator is a logic operator.

For example, ‘Binary(Binary(a, >, b), AND, Binary(a, <, b + 3))’ would be a logical expression.

pub fn swap(&self) -> Option<Operator>

Return the operator where swapping lhs and rhs wouldn’t change the result.

For example Binary(50, >=, a) could also be represented as Binary(a, <=, 50).

pub fn precedence(&self) -> u8

Get the operator precedence use https://www.postgresql.org/docs/7.2/sql-precedence.html as a reference

Trait Implementations

impl Clone for Operator

fn clone(&self) -> Operator

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for Operator

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

Formats the value using the given formatter.

impl Display for Operator

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

Formats the value using the given formatter.

impl Hash for Operator

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

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 PartialEq for Operator

fn eq(&self, other: &Operator) -> 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 Operator

fn partial_cmp(&self, other: &Operator) -> 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 Copy for Operator

impl Eq for Operator

impl StructuralPartialEq for Operator