Re: [ADMIN] About lower and uppercase

select * from fruits where fruit_name ~* 'orange';


Stephan Szabo wrote:
On Mon, 4 Nov 2002, [iso-8859-1] Sonia S?nchez D?az 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.