pub enum JsonOperator {
Arrow,
LongArrow,
HashArrow,
HashLongArrow,
Colon,
AtArrow,
ArrowAt,
HashMinus,
AtQuestion,
AtAt,
}
Expand description
JsonOperator
Variants§
Arrow
-> keeps the value as json
LongArrow
->> keeps the value as text or int.
HashArrow
#> Extracts JSON sub-object at the specified path
HashLongArrow
#>> Extracts JSON sub-object at the specified path as text
Colon
: Colon is used by Snowflake (Which is similar to LongArrow)
AtArrow
jsonb @> jsonb -> boolean: Test whether left json contains the right json
ArrowAt
jsonb <@ jsonb -> boolean: Test whether right json contains the left json
HashMinus
jsonb #- text[] -> jsonb: Deletes the field or array element at the specified path, where path elements can be either field keys or array indexes.
AtQuestion
jsonb @? jsonpath -> boolean: Does JSON path return any item for the specified JSON value?
AtAt
jsonb @@ jsonpath → boolean: Returns the result of a JSON path predicate check for the specified JSON value. Only the first item of the result is taken into account. If the result is not Boolean, then NULL is returned.
Trait Implementations§
Source§impl Clone for JsonOperator
impl Clone for JsonOperator
Source§fn clone(&self) -> JsonOperator
fn clone(&self) -> JsonOperator
1.0.0 · Source§fn clone_from(&mut self, source: &Self)
fn clone_from(&mut self, source: &Self)
source
. Read more