Postgres Pro
Downloads
Home   >   mailing lists

error with operator ~~ for varchar - Mailing list pgsql-general

From Yury Don
Subject error with operator ~~ for varchar
Date
Msg-id 2588.000201@vpcit.ru
Whole thread Raw
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Tim Joyce"
Date:
Subject: select distinct
Next
From: Sevo Stille
Date:
Subject: Re: [GENERAL] Linking in sin() as a C function