Redefining LIKE operator

Hi,

I need the LIKE operator to be case insensitive.
What I did is to redefine the ~~ so it behaves as the ~~* operator:

DROP OPERATOR ~~ (name, text);
CREATE OPERATOR ~~ ( leftarg=name, rightarg=text, procedure=nameiclike,
negator='!~~');


The operator is created, but when I execute a query, LIKE is still being
case-sensitive.
Am I doing anything wrong?
Is it not possible to redefine this operator?
I am using the 7.2.2 version.



Thanks in advance


Pablo Sajnin
psajnin@bejerman.com.ar