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

From: David Hartwig <daveh(at)insightdist(dot)com>
To: Marcio Macedo <marciom(at)conectiva(dot)com(dot)br>
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 17:47:53
Message-ID: 35EC3349.FE4C20FC@insightdist.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Sergei Barbarash 1998-09-02 07:07:42 indexing datetime
Previous Message Leslie Mikesell 1998-09-01 17:24:33 rename table - primary key index?