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.