#[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
<->
. L2 (Euclidean) distance operator
NegativeInnerProduct
<#>
. Negative inner product operator
CosineDistance
<=>
. Cosine distance operator