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