opteryx icon indicating copy to clipboard operation
opteryx copied to clipboard

✨ Expand JSON accessors

Open joocer opened this issue 1 year ago • 0 comments

/// `#>`, extracts JSON sub-object at the specified path
HashArrow

/// `#>>`, extracts JSON sub-object at the specified path as text
HashLongArrow

/// jsonb @> jsonb -> boolean: Test whether left json contains the right json
AtArrow

/// jsonb <@ jsonb -> boolean: Test whether right json contains the left json
ArrowAt

/// 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.
AtAt

joocer avatar Aug 13 '24 15:08 joocer