Wiki / Operators

get jsonb array element as text

Left operand

jsonb

Right operand

int4

Result type

text

Implementing function

jsonb_array_element_text(jsonb,int4)

Operator kind

Binary

Hash join candidate

no

Merge join candidate

no

aliases

->>, ->>(jsonb,int4)

manual semantics

Exact operand/result signature matched

memberships

Unknown

signature

->>(jsonb,int4) → text

source oid

3481

{"commutator":"","function":"jsonb_array_element_text(jsonb,int4)","hash_join":"f","kind":"b","left_type":"jsonb","merge_join":"f","negator":"","result_type":"text","right_type":"int4","symbol":"-\u003e\u003e"}