Wiki / Operators

matches regular expression, case-insensitive

Left operand

bpchar

Right operand

text

Result type

bool

Implementing function

bpcharicregexeq(bpchar,text)

Operator kind

Binary

Hash join candidate

no

Merge join candidate

no

aliases

~*, ~*(bpchar,text)

manual semantics

Source catalog description; no additional matching manual operator definition claimed

memberships

Unknown

signature

~*(bpchar,text) → bool

source oid

1234

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