Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id BE68F9FB653 for ; Thu, 25 Jan 2007 11:10:08 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 22270-06 for ; Thu, 25 Jan 2007 11:09:56 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from momjian.us (momjian.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id E30D09FB20B for ; Thu, 25 Jan 2007 11:10:01 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id l0PF9nR28732; Thu, 25 Jan 2007 10:09:49 -0500 (EST) From: Bruce Momjian Message-Id: <200701251509.l0PF9nR28732@momjian.us> Subject: Re: Case-sensitive In-Reply-To: To: Shoaib Mir Date: Thu, 25 Jan 2007 10:09:49 -0500 (EST) CC: "Alexander B." , "pgsql-admin@postgresql.org" X-Mailer: ELM [version 2.4ME+ PL123] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/245 X-Sequence-Number: 24401 And there is an FAQ about this. --------------------------------------------------------------------------- Shoaib Mir wrote: > 'citext' module (http://gborg.postgresql.org/project/citext/projdisplay.php) > might help you with this.... > > ----------- > Shoaib Mir > EnterpriseDB (www.enterprisedb.com) > > On 1/25/07, Alexander B. wrote: > > > > Hi, > > > > One developer asked me about case-sensitive, if its possible disable > > Postgres not consider when using comparative functions. > > Eg.: > > select * from people > > where upper(name) like upper('A%'); > > > > Is there any parameter that don't take in account case-sensitive, or any > > other way to treat?? > > > > Thanks > > > > > > > > > > > > > > _______________________________________________________ > > Yahoo! Mail - Sempre a melhor op??o para voc?! > > Experimente j? e veja as novidades. > > http://br.yahoo.com/mailbeta/tudonovo/ > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 2: Don't 'kill -9' the postmaster > > -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +