From: | Barracuda <cuda_fx(at)yahoo(dot)com> |
---|---|
To: | Marcio Macedo <marciom(at)conectiva(dot)com(dot)br>, David Hartwig <daveh(at)insightdist(dot)com> |
Cc: | pgsql-sql(at)postgreSQL(dot)org, "S(dot)Ramaswamy" <srswamy(at)giasdl01(dot)vsnl(dot)net(dot)in> |
Subject: | Re: [SQL] How to Make Case InSensitive??? |
Date: | 1998-09-16 13:48:10 |
Message-ID: | 19980916134810.21155.rocketmail@send101.yahoomail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)insightdist(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Sferacarta Software | 1998-09-16 14:14:20 | Re[2]: [SQL] How to Make Case InSensitive??? |
Previous Message | Sferacarta Software | 1998-09-16 13:35:08 | Re: [SQL] create a new user in a group |