Re: [SQL] How to Make Case InSensitive??? - Mailing list pgsql-sql

Marcio Macedo wrote:

> Hey...
>
> How does this " ~* " operator works ?!?!?!
>
> David Hartwig wrote:
> >
> >
> >      SELECT * FROM series WHERE upper(NAME) = 'INDIA'
> >                             or
> >      SELECT * FROM series WHERE NAME ~* '^india$'

>

I don't use it myself, but it is a case insensitive regular expression
match operator.    "~' is the case sensitive operator.    Do "\do" in
psql to see all the operators.