Thanks!!! I use ilike and I get the result that I want...
Thanks!!!!! Regards! Original Message: ----------------- From: Stephan Szabo [EMAIL PROTECTED] Date: Mon, 04 Nov 2002 21:50:06 -0800 (PST) To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: [ADMIN] About lower and uppercase 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. -------------------------------------------------------------------- mail2web - Check your email from the web at http://mail2web.com/ . ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster