Try using ~*
Her are the General Operators:
"Campbell, Scott" wrote:
> 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?
In response to
pgsql-general by date
|Next:||From: Travis Bauer||Date: 2000-08-30 13:52:06|
|Subject: Cursors and JDBC|
|Previous:||From: Jules Bean||Date: 2000-08-30 13:32:51|
|Subject: Re: Large selects handled inefficiently?|