Wiki / Operators

get value from jsonb with path elements

Left operand

jsonb

Right operand

_text

Result type

jsonb

Implementing function

jsonb_extract_path(jsonb,_text)

Operator kind

Binary

Hash join candidate

no

Merge join candidate

no

aliases

#>, #>(jsonb,_text)

manual semantics

Exact operand/result signature matched

memberships

Unknown

signature

#>(jsonb,_text) → jsonb

source oid

3213

{"commutator":"","function":"jsonb_extract_path(jsonb,_text)","hash_join":"f","kind":"b","left_type":"jsonb","merge_join":"f","negator":"","result_type":"jsonb","right_type":"_text","symbol":"#\u003e"}