Wiki / Operators

get value from jsonb as text with path elements

Left operand

jsonb

Right operand

_text

Result type

text

Implementing function

jsonb_extract_path_text(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) → text

source oid

3206

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