#[non_exhaustive]pub enum PgBinOper {
Show 20 variants
ILike,
NotILike,
Matches,
Contains,
Contained,
Concatenate,
Overlap,
Similarity,
WordSimilarity,
StrictWordSimilarity,
SimilarityDistance,
WordSimilarityDistance,
StrictWordSimilarityDistance,
GetJsonField,
CastJsonField,
Regex,
RegexCaseInsensitive,
EuclideanDistance,
NegativeInnerProduct,
CosineDistance,
}backend-postgres only.Expand description
Postgres-specific binary operators.
For all supported operators (including the standard ones), see BinOper.
Variants (Non-exhaustive)ยง
This enum is marked as non-exhaustive
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
postgres-vector only.<->. L2 (Euclidean) distance operator
NegativeInnerProduct
postgres-vector only.<#>. Negative inner product operator
CosineDistance
postgres-vector only.<=>. Cosine distance operator