Wiki / Operators

concatenate

Left operand

jsonb

Right operand

jsonb

Result type

jsonb

Implementing function

jsonb_concat(jsonb,jsonb)

Operator kind

Binary

Hash join candidate

no

Merge join candidate

no

aliases

||, ||(jsonb,jsonb)

manual semantics

Exact operand/result signature matched

memberships

Unknown

signature

||(jsonb,jsonb) → jsonb

source oid

3284

{"commutator":"","function":"jsonb_concat(jsonb,jsonb)","hash_join":"f","kind":"b","left_type":"jsonb","merge_join":"f","negator":"","result_type":"jsonb","right_type":"jsonb","symbol":"||"}