Upper and Lower case sensitivities - Mailing list pgsql-general

From Campbell, Scott
Subject Upper and Lower case sensitivities
Date
Msg-id ED7A447524CCD311A9BF009027DC86ED011E39FB@NSEXCH02
Whole thread Raw
Responses Re: Upper and Lower case sensitivities
List pgsql-general
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

pgsql-general by date:

Previous
From: Jules Bean
Date:
Subject: Large selects handled inefficiently?
Next
From: Steve Heaven
Date:
Subject: Re: Upper and Lower case sensitivities