Re: [SQL] How to Make Case InSensitive???

thank you for this tip!  don't know what the ^ or the $ is used for
but the ~* and the \do helped me out a great deal.  No info on this in
any documentation.

Charles




---David Hartwig <daveh@insightdist.com> wrote:
>
> 
> 
> 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.
> 
> 
> 

_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com