Re: Redefining LIKE operator

The problem is that I am migrating a system from MS Sql Server (which was
installed with the case-insensitive option) and the system will have to
still keep working with this RDBMS after the migration, so I have to change
the code as less as possible...

-----Mensaje original-----
De: Larry Rosenman [mailto:ler(at)lerctr(dot)org]
Enviado el: Viernes, 14 de Marzo de 2003 09:16 a.m.
Para: Pablo Sajnn; pgsql-general(at)postgresql(dot)org
Asunto: Re: [GENERAL] Redefining LIKE operator

--On Friday, March 14, 2003 09:06:29 -0300 Pablo Sajnn
<psajnin(at)bejerman(dot)com(dot)ar> wrote:

> 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.
>
What's wrong with ILIKE?

>
>
> Thanks in advance
>
>
> Pablo Sajnin
> psajnin(at)bejerman(dot)com(dot)ar
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749