Thread: error with operator ~~ for varchar

error with operator ~~ for varchar

From
Yury Don
Date:
Hello All,

I would like to redefine the behavior of operator "like" ("~~") for varchar, but I am
getting the following error:

tmp=> drop operator ~~ (varchar, text);
ERROR:  parser: parse error at or near "varchar"
tmp=>

What does it mean?
With "~~ (text, text)" everything works.

--
Best regards,
 Yury  ICQ 11831432
 mailto:yura@vpcit.ru