Re: About lower and uppercase

On Mon, 4 Nov 2002, [iso-8859-1] Sonia Snchez Daz wrote:

> Hi!
>
> I don't know if this is possible from postgresql configuration...
>
> I want to ignore the use of uppercase and lowercase from the data restored
> into the DB...
>
> I mean, if I write a query like this:
>
> select * from fruits where fruit_name like 'orange';
>
> I could get any result where the string looks like:
>
> orange
> Orange
> ORANGE
>
> Is it possible???

Not really without doing a little bit of changing
to the query (for example using ILIKE rather than LIKE
or lower(fruit_name) like 'orange' with an appropriate
index on lower(fruit_name).

Theoretically, it could perhaps be possible to create a locale
which compare 'orange' and 'OraNgE' equally and then
initdb in that locale, but I've never tried it so I don't
know if it'd work.