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

Hey...

How does this " ~* " operator works ?!?!?!


David Hartwig wrote:
>
>
>      SELECT * FROM series WHERE upper(NAME) = 'INDIA'
>                             or
>      SELECT * FROM series WHERE NAME ~* '^india$'

--Marcio Macedo
    Conectiva