Wiki / Operators

matches LIKE expression

Left operand

text

Right operand

text

Result type

bool

Implementing function

textlike(text,text)

Operator kind

Binary

Hash join candidate

no

Merge join candidate

no

aliases

~~, ~~(text,text)

manual semantics

Source catalog description; no additional matching manual operator definition claimed

memberships

Unknown

signature

~~(text,text) → bool

source oid

1209

{"commutator":"","function":"textlike(text,text)","hash_join":"f","kind":"b","left_type":"text","merge_join":"f","negator":"!~~(text,text)","result_type":"bool","right_type":"text","symbol":"~~"}