Enum Operator 

pub enum Operator {
    Eq,
    Ne,
    Gt,
    Gte,
    Lt,
    Lte,
    Fuzzy,
    In,
    NotIn,
    IsNull,
    IsNotNull,
    Contains,
    KeyExists,
    JsonExists,
    JsonQuery,
    JsonValue,
    Like,
    NotLike,
    ILike,
    NotILike,
    Between,
    NotBetween,
    Exists,
    NotExists,
    Regex,
    RegexI,
    SimilarTo,
    ContainedBy,
    Overlaps,
}

Variants

Eq

Ne

Not equal (!=, <>)

Gt

Greater than (>)

Gte

Greater than or equal (>=)

Lt

Less than (<)

Lte

Less than or equal (<=)

Fuzzy

In

NotIn

IsNull

IsNotNull

Contains

KeyExists

JsonExists

JSON_EXISTS - check if path exists (Postgres 17+)

JsonQuery

JSON_QUERY - extract JSON object/array at path (Postgres 17+)

JsonValue

JSON_VALUE - extract scalar value at path (Postgres 17+)

Like

NotLike

ILike

ILIKE case-insensitive pattern match (Postgres)

NotILike

NOT ILIKE case-insensitive pattern match (Postgres)

Between

BETWEEN x AND y - range check (value stored as Value::Array with 2 elements)

NotBetween

Exists

EXISTS (subquery) - check if subquery returns any rows

NotExists

Regex

Regular expression match (~ in Postgres)

RegexI

Case-insensitive regex (~* in Postgres)

SimilarTo

ContainedBy

Overlaps

Array overlap (&&)

Implementations

impl Operator

pub fn sql_symbol(&self) -> &'static str

For simple operators, returns the symbol directly. For complex operators (BETWEEN, EXISTS), returns the keyword.

pub fn needs_value(&self) -> bool

IS NULL, IS NOT NULL, EXISTS, NOT EXISTS don’t need values.

pub fn is_simple_binary(&self) -> bool

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<'de> Deserialize<'de> for Operator

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

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

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl Copy for Operator

impl Eq for Operator

impl StructuralPartialEq for Operator