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

From: Marcio Macedo <marciom(at)conectiva(dot)com(dot)br>
To: David Hartwig <daveh(at)insightdist(dot)com>
Cc: "S(dot)Ramaswamy" <srswamy(at)giasdl01(dot)vsnl(dot)net(dot)in>, pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] How to Make Case InSensitive???
Date: 1998-09-01 14:14:47
Message-ID: 35EC0157.950EFE6D@conectiva.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message S.Ramaswamy 1998-09-01 16:02:15 How to Make Case InSensitive???
Previous Message Johann Spies 1998-09-01 11:57:12 pgaccess-forms.