Skip site navigation (1) Skip section navigation (2)

Re: Upper and Lower case sensitivities

From: "Poul L(dot) Christiansen" <poulc(at)miba(dot)auc(dot)dk>
To: "Campbell, Scott" <scampbell1(at)mtt(dot)ca>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Upper and Lower case sensitivities
Date: 2000-08-30 13:34:47
Message-ID: 39AD0D77.7A172047@miba.auc.dk (view raw or flat)
Thread:
Lists: pgsql-general
Try using ~*

Her are the General Operators:
http://www.postgresql.org/docs/user/x2125.htm

"Campbell, Scott" wrote:

> Hey,
>
> Is there a function within postgres that lets you search for both upper and
> lower case at the same time?
> I know of the upper() and lower() functions but if a word has both upper and
> lower case in it it won't be returned by a query.
> Or am I limited to forcing my data to have one case only?
>
> Thanks
> Scott


In response to

pgsql-general by date

Next:From: Travis BauerDate: 2000-08-30 13:52:06
Subject: Cursors and JDBC
Previous:From: Jules BeanDate: 2000-08-30 13:32:51
Subject: Re: Large selects handled inefficiently?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group