Enum PgBinOper 

#[non_exhaustive]
pub enum PgBinOper {
    ILike,
    NotILike,
    Matches,
    Contains,
    Contained,
    Concatenate,
    Overlap,
    Similarity,
    WordSimilarity,
    StrictWordSimilarity,
    SimilarityDistance,
    WordSimilarityDistance,
    StrictWordSimilarityDistance,
    GetJsonField,
    CastJsonField,
    Regex,
    RegexCaseInsensitive,
    EuclideanDistance,
    NegativeInnerProduct,
    CosineDistance,
}

Available on crate feature backend-postgres only.

Postgres-specific binary operators.

For all supported operators (including the standard ones), see BinOper.

Variants (Non-exhaustive)

Non-exhaustive enums could have additional variants added in future. Therefore, when matching against variants of non-exhaustive enums, an extra wildcard arm must be added to account for any future variants.

ILike

NotILike

Matches

@@. Full-text search match

Contains

@>. Contains operator - checks if left operand contains right operand (arrays, JSON)

Contained

<@. Contained operator - checks if left operand is contained by right operand (arrays, JSON)

Concatenate

||. String/Array concatenation operator

Overlap

&&. Overlap operator - checks if arrays have any elements in common

Similarity

%. Text similarity operator, requires pg_trgm extension

WordSimilarity

<%. Word similarity operator, requires pg_trgm extension

StrictWordSimilarity

<<%. Strict word similarity operator, requires pg_trgm extension

SimilarityDistance

<->. Similarity distance operator, requires pg_trgm extension

WordSimilarityDistance

<<->. Word similarity distance operator, requires pg_trgm extension

StrictWordSimilarityDistance

<<<->. Strict word similarity distance operator, requires pg_trgm extension

GetJsonField

->. Retrieves JSON field as JSON value

CastJsonField

->>. Retrieves JSON field and casts it to text

Regex

~. Regex operator, case sensitively

RegexCaseInsensitive

~*. Regex operator, case-insensitively

EuclideanDistance

Available on crate feature postgres-vector only.

<->. L2 (Euclidean) distance operator

NegativeInnerProduct

Available on crate feature postgres-vector only.

<#>. Negative inner product operator

CosineDistance

Available on crate feature postgres-vector only.

<=>. Cosine distance operator

Trait Implementations

impl Clone for PgBinOper

fn clone(&self) -> PgBinOper

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Copy for PgBinOper

impl Debug for PgBinOper

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

Formats the value using the given formatter.

impl Eq for PgBinOper

impl From<PgBinOper> for BinOper

fn from(o: PgBinOper) -> Self

Converts to this type from the input type.

impl PartialEq for PgBinOper

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

Equality operator ==.

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

Inequality operator !=.

impl StructuralPartialEq for PgBinOper