Wiki / Operators

matches regular expression, case-insensitive

Left operand

text

Right operand

text

Result type

bool

Implementing function

texticregexeq(text,text)

Operator kind

Binary

Hash join candidate

no

Merge join candidate

no

aliases

~*, ~*(text,text)

manual semantics

Exact operand/result signature matched

memberships

Unknown

signature

~*(text,text) → bool

source oid

1228

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